-f tbalter

This BRSPACE function alters tables. For more information, see Altering Tables with BR*Tools.

Function options:

• -a|-action: specifies the action to alter tables

  Syntax: -a|-action crsegm|drsegm|monit|nomonit|parallel|shrink

  • crsegm creates a table segment

  • drsegm drops a table segment

  • monit sets the monitoring attribute on

  • nomonit sets the monitoring attribute off

  • parallel sets the degree of parallelism for queries

  • shrink shrinks table segments and BasicFile LOB columns online (Oracle 10g or higher)

  Default: none, since you must always specify the action

• -d|-degree: specifies the degree for parallel queries

  Syntax: -d|-degree <degree>

  1 specifies normal serial processing

  >1 specifies parallel query

  Default: 0 (use Oracle default)

• -o|-owner: defines the SAP owner of the tables to be altered - useful in Multiple Components in One Database (MCOD) configurations

  Syntax: -o|-owner <owner>|<owner_list>

  <owner> or <owner_list> specifies the name of the SAP owner or owners

  Default: all SAP owners in MCOD, otherwise the single SAP owner

• -s|-tablespace: specifies the tablespace of the tables to be altered

  Syntax: -s|-tablespace <tablespace>|<tablespace list>

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

  Default: none

• -t|-table: specifies the tables to be altered

  Syntax: -t|-table all|allsel|[<owner>.]<table>|

  [<owner>.][<prefix>]%[<suffix>]|

  [<owner>.][<prefix>]*[<suffix>]|<table_list>

  where:

  all or “%” means preselect

  allsel or “*” means final select:

  For more information about wildcards for preselect and select, see Selecting Objects in Segment Management with BR*Tools.

  Default: all (preselection)