-f tbalter

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