Segment Management with BR*Tools

Use

You can manage the segments – that is, tables and indexes – on your Oracle database with BR*Tools .

This section describes how you manage segments with BR*Tools.

For more information on the approach to manage segments, see Segment Management.

Integration

·        BRGUI or BRTOOLS calls the SAP tool BRSPACE. You can also manage segments by calling BRSPACE from the command line. However, unless you choose batch mode with the option –c force, BRSPACE displays menus to help you enter the required options.

We recommend you to normally use BRGUI or BRTOOLS rather than BRSPACE. This is because the menus in BRGUI or BRTOOLS simplify entry of the correct options.

·        If required, set the following parameters for BRSPACE in the Initialization Profile init<DBSID>.sap:

Ў        scroll_lines and show_period. to control the screen display

Ў        reorg_table to specify a list of tables for reorganization

Ў        rebuild_index to specify a list of indexes for rebuild

Ў        exp_table to specify a list of tables for export

Ў        imp_table to specify a list of tables for import

Features

You can perform the following functions for segment management with BR*Tools:

·        Reorganize tables

·        Rebuild indexes

·        Export tables

·        Import tables

·        Alter tables

·        Alter indexes

Activities

...

       1.      You choose Segment management in the BRGUI or BRTOOLS menus or directly from the command line. You can use quick mode if you know which objects you require. For more information on quick mode, see BR*Tools User Interface

       2.      If required, you change the default values for the parameters in the initialization profile init<DBSID>.sap and restart BRGUI or BRTOOLS.

       3.      If required, you choose Segment Management ® Reset program status to set the defaults used to the values set after BRGUI or BRTOOLS initialization.

       4.      You start segment management.

You check the results of segment management in the BRSPACE logs.

Selecting Objects

You can select the objects – that is, the tables or indexes – for segment management functions in one or more of the following ways:

·        By specifying tables or indexes directly by name

·        By specifying a tablespace name – all objects in the specified tablespace are selected

·        By specifying the owner name – all objects with the specified owner are selected. This is useful for systems with Multiple Components in One Database (MCOD).

Selecting Multiple Objects

When specifying tables or indexes directly by name, you can use wildcards or a parameter in the initialization profile init<DBSID>.sap to select multiple tables or indexes.

·        Wildcards

When you use BRGUI or BRTOOLS, or call BRSPACE from the command line, you can use one of the following types of wildcard:

Ў        Final selection wildcard, using the character “*”

If you enter DBA*, BRSPACE selects all tables or indexes beginning with the characters “DBA.”

BRSPACE displays a list of tables or indexes meeting your selection criterion, but this is only for confirmation. You cannot make a further selection.

Ў        Pre-selection wildcard, using the character “%”

If you enter DBA%, BRSPACE preselects all tables or indexes beginning with the characters “DBA.”

BRSPACE displays a list of tables or indexes meeting your selection criterion. You can now make a further selection from this list, if required.

Note the following features when using wildcards:

·         You must always put the wildcard at the end.

For example, DBA* is valid, but DB*A is not valid.

·         Wildcards are not valid for tablespaces or owners. That is, you can only use wildcards to directly specify groups of tables or indexes.

·         If you use wildcards on the final object to select multiple objects in quick mode, BRSPACE displays a list of objects for confirmation.

The final object is the one specified in the function name – that is, table for the functions reorganize, export, import, or alter tables, or index for the function alter or rebuild indexes.

·         You can make a final selection with wildcards only on the final object for the function.

For example, for the function “Alter index” you can only make a final selection with a wildcard by entering “*” or “<prefix>*” in the index name field. If you enter “*” or “<prefix>*” in the table name field for “Alter index,” this is treated as a pre-selection wildcard.

·        You can use the following parameters from the initialization profile init<DBSID>.sap to specify a long list of object names:

Ў        reorg_table specifies a list of tables to reorganize

Ў        rebuild_index specifies a list of indexes to rebuild

Ў        exp_table specifies a list of tables to export

Ў        imp_table specifies a list of tables to import