-f dfalter

This BRSPACE function alters a data file. For more information, see Altering a Data File with BR*Tools.

Function options:

• -a|-action: specifies the action to alter the tablespace

  Syntax: -a online|offline|autoext|drop|fixsize|rename|resize

  • online sets the data file online

  • offline sets the data file offline

  • autoext switches on or maintains autoextend

  • fixsize switches off autoextend

  • resize resizes the data file

  • rename renames the data file

  • drop drops the empty data file

  Default: none, since you must always specify the action

• -c|-force: forces offline mode and stop database

  Default: do not set offline or stop database if a SAP user is connected

• -f|-file: specifies the data file name

  Syntax: -f|-file all_df|<file>|<file_id>|<file_id1>-<file_id2>| <sapdata_dir>|sapdata<N>|sapraw|<win_drive>:|+<asm_disk>|<file_list>

  all_df: all eligible data files (for example, from the specified tablespaces)

  <file>|<file_id>|<file_list>: specifies the data file(s) using the file names / IDS

  <sapdata_dir>|sapdata<N>|sapraw: specifies the data file(s) using sapdata / sapraw directory

  <win_drive>: specifies the data file(s) using the Windows disk drive letter

  +<asm_disk>: specifies the data file(s) using the ASM disk group

  Default: none, since you must always define the file name

• -i|-incrsize: specifies the new data file increment size

  Syntax: -i|-incrsize <size>

  <size> specifies the size in MB

  Default: none, since you must always specify the new file increment size

• -m|-maxsize: specifies the new maximum data file size

  Syntax: -m|-maxsize <size>

  <size> specifies the size in MB. 0 sets the maximum database size to unlimited (maximum 32 GB for SAP standard of 8 KB database block size).

  Default: none, since you must always specify the maximum file size

• -n|-name: specifies the new data file name

  Syntax: -n|-name <new_name>

  <new_name> specifies the new data file name, according to SAP conventions

  Default: none, since you must always specify the new file name

• -s|-size: specifies the new data file size

  Syntax: -s|-size <size>

  <size> specifies the size in MB

  Default: none, since you must always specify the new file size

• -t|-tablespace: specifies the tablespace(s) for which data files are to be altered

  Syntax: -t|-tablespace <tablespace>|<tablespace_list>

  Default: none, but you can specify data files explicitly with option -f (see above).