Show TOC Start of Content Area

Syntax documentation -f tsalter  Locate the document in its SAP Library structure

This BRSPACE function  alters a tablespace. For more information, see Altering a Tablespace with BR*Tools.

Function options:

·        -a|-action: specifies the action to alter the tablespace

Syntax: -a|-action online|offline|begback|endback|coalesce

¡        online sets the tablespace online

¡        offline sets the tablespace offline

¡        begback sets backup status

¡        endback resets backup status

¡        coalesce coalesces free extents

¡        rename renames a tablespace (Oracle 10g or higher)

Default: none, since you must always define the action

·        -f|-force: forces offline mode

Default: do not set offline if a SAP user is connected

·        -m|-mode: defines the mode in which the tablespace is set offline

Syntax: -m|-mode normal|immediate|temporary

For more information on offline mode, see the Oracle documentation.

·        -n|-name: defines the new tablespace name

Syntax: -n|-name <name>

Default: none, since you must alwas specify the new name

·        -t|-tablespace: defines the tablespace to be altered

Syntax: -t|-tablespace all_ts|<tablespace>|<tablespace list>

all_ts: all eligible tablespaces

<tablespace> or <tablespace list> specifies the tablespace name(s)

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

 

End of Content Area