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|fixsize|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
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_list>
all_df: all eligible data files (for example, from the specified tablespaces)
<file>|<file_id>|<file_list> specifies the data file(s)
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
Default: none, since you must always specify the maximum file size
· -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).