Show TOC

Segment Management with BR*ToolsLocate this document in the navigation structure

Use

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

Note

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.

    Recommendation

    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:

Features

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

  • Reorganize tables or table partitions

  • Rebuild indexes or index partitions

  • 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 Start of the navigation path Segment Management Next navigation step Reset program status End of the navigation path 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 “*”

      Example

      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 “%”.

      Example

      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

      Note the following features when using wildcards:

      • You can put the wildcard anywhere in the object name.

        For example, DBA*, DB*A, or *DBA are all valid..

      • You can only use one wildcard.

        For example, DB*A*B 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.