-f dfalterThis 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).