This BRSPACE function extends a tablespace. For more information, see Extending a Tablespace with BR*Tools. You can add up to five files to a tablespace with this function.
Function options:
· -a|-autoextend: sets autoextend mode for the data file so that Oracle automatically extends the tablespace as it grows
Syntax: -a|-autoextend[1|2|3|4|5]
[1|2|3|4|5] specifies the sequence number of the file to be added to the tablespace
Default: as for the last data file added to the tablespace
· -f|-file: defines the data file to extend the tablespace
Syntax: -f|-file[1|2|3|4|5] <file>|<sapdata_dir>|sapdata<N>|<N>
[1|2|3|4|5] specifies the sequence number of the file to be added to the tablespace
<file> specifies the full name of the data file
<sapdata_dir> specifies the path name to the sapdata directory where the new file will be located
sapdata<N> or <N>specifies the name or number of the sapdata directory where the new file is located
BRSPACE automatically extends the incomplete file name to the full name using the SAP naming conventions.
Default: generated automatically according to SAP naming conventions (recommended) in the sapdata directory used by last file added to the tablespace
· -i|-incrsize: defines the increment by which the file is extended if autoextend is set
Syntax: -i|-incrsize[1|2|3|4|5] <size>
[1|2|3|4|5] specifies the sequence number of the file to be added to the tablespace
<size> specifies the size of the increment in MB
Default: as for the last data file added to the tablespace
· -m|-maxsize: defines the maximum file size to which the file can be extended if autoextend is set
Syntax: -m|-maxsize[1|2|3|4|5] <size>
<size> specifies the maximum file size in MB
[1|2|3|4|5] specifies the sequence number of the file to be added to the tablespace
Default: as for the last data file added to the tablespace
· -r|-rawlink: defines the destination of a raw disk or a link to a non-sapdata directory. This is defined as follows:
¡ For a raw disk, the SAP convention is to specify a softlink in the directory /oracle/<DBSID>/sapraw
¡ For a link to a destination outside sapdata, such as to /oracle/temp, the new file is added as a symbolic link
Syntax: -r|-rawlink[1|2|3|4|5] <link target>
[1|2|3|4|5] specifies the sequence number of the file to be added to the tablespace
<link target> specifies the link target
Default: no raw link
· -s|-size: defines the data file size
Syntax: -s|-size[1|2|3|4|5] <size>
[1|2|3|4|5] specifies the sequence number of the file to be added to the tablespace
<size> specifies the data file size in MB
Default: as for the last file added to the tablespace
· -t|-tablespace: Defines the tablespace to be extended
Syntax: -t|-tablespace[1|2|3|4|5] <tablespace>
[1|2|3|4|5] specifies the sequence number of the file to be added to the tablespace
<tablespace> specifies the tablespace name
Default: none, since you must always define the tablespace name