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