This BRSPACE function alters indexes. For more information, see Altering Indexes with BR*Tools.
Function options:
-a|-action: specifies the action to alter indexes
Syntax: -a|-action coalesce|monit|nomonit|parallel|shrink
coalesce merges internal index data
monit switches on index usage monitoring
nomonit switches off index usage monitoring
parallel sets the degree of parallelism for queries
shrink shrinks the index 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)
-i|-index: specifies the indexes to be altered
Syntax: -i|-index all|allsel|[<owner>.]<index>|
[<owner>.][<prefix>]%[<suffix>]|
[<owner>.][<prefix>]*[<suffix>]|<index_list>
where:
all or “%” means preselect
allsel or “*” means final select:
For more information about wildcards, see Selecting Objects in Segment Management with BR*Tools.
Default: all (preselection)
-o|-owner: defines the SAP owner of the indexes 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
Default: all SAP owners in MCOD, otherwise the single SAP owner
-s|-tablespace: specifies the tablespace of the indexes 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 of the indexes to be altered
Syntax:
Syntax: -t|-table all|allsel|[<owner>.]<table>|
[<owner>.][<prefix>]%[<suffix>]|
[<owner>.][<prefix>]*[<suffix>]|<table_list>
where:
all or “%” means preselect
allsel or “*” means here also preselect:
For more information about wildcards for preselect and select, see Selecting Objects in Segment Management with BR*Tools.
Default: none