-f tsextend

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