This BRSPACE function alters tables. For more information, see Altering a Table with BR*Tools.
Function options:
· -a|-action: specifies the action to alter tables
Syntax: -a|-action monit|nomonit|parallel|shrink
¡ monit sets the monitoring attribute on
¡ nomonit sets the monitoring attribute off
¡ parallel sets the degree of parallelism for queries
¡ shrink shrinks table segments 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> specifies the name of the SAP owner
Default: no default 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 [<owner>.]<table>|[<owner>.]<prefix>%|%|
[<owner>.]<prefix>*|*|<table_list>
Wildcards: “%” means preselect, “*” means final select
For more information on wildcards for preselect and select, see “Selecting Objects” in Segment Management with BR*Tools.
Default: none, since you must always specify a table to alter