-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] no|yes

  [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>|sapraw|+<asm_disk>

  [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

  sapraw specifies the directory for a softlink to raw disks

  +<asm_disk> specifies an ASM disk group

  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 or ASM disk group 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. 0 sets the maximum database size to unlimited (maximum 32 GB for SAP standard of 8 KB database block size).

  [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 create a softlink in the directory /oracle/<DBSID>/sapraw

  • For a link to a destination outside sapdata, such as to /oracle/temp, the new file subdirectory 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 <tablespace>

  <tablespace> specifies the tablespace name

  Default: none, since you must always define the tablespace name