Show TOC

Syntax documentation-f tsalter Locate this document in the navigation 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 always 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