-f idalter

Procedure

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