Moving a Table or Index (SAP Library - Database Administration (Oracle) with SAPDBA)

Moving a Table or Index

Reorganize single table or index

By specifying a tablespace other than the target tablespace, you can move an individual object to a different tablespace during a reorganization.

In addition to the familiar objects and checks from the reorganization of a single object, SAPDBA also performs the following operations:

Checks whether the specified tablespace corresponds to the SAP naming convention. If not, the entry is rejected.

The specified tablespace cannot be one of the ORACLE tablespaces SYSTEM, PSAPROLL or PSAPTEMP (see SAP Naming Convention: Tablespace Names).

When you move a table, the corresponding indexes are automatically moved to the corresponding tablespace. If the corresponding tablespace does not exist or is too small, the entry is rejected.

Example: when a table that is part of tablespace PSAPBSPD is reorganized, the corresponding indexes are stored in tablespace PSAPBSPI.

If an index to be reorganized does not lie in the corresponding tablespace, the corresponding tablespace is the automatic default value for the target tablespace.

Example: the table of the index to be reorganized lies in tablespace PSAPBSPD. As a result, tablespace PSAPBSPI is suggested as the default target tablespace for the index.

SAPDBA updates the data type of the table in SAP table DD09L.

Other Types of Reorganization

Using the option Use ABAP/4-Dic for tablespaces: yes you can create the objects to be reorganized in the tablespace which was defined for the objects by specifying a data type. See Technical Configuration.

SAPDBA also performs the following operations in addition to the known actions and checks for reorganizing a single object:

Check if there is an entry in table DD09L for the objects.

There is no entry: The objects are created in the original tablespace.
There is an entry: The objects are created in tablespaces in accordance with the information in tables DD09L and TAORA/IAORA.

If you move a table, the corresponding indexes are automatically moved to the corresponding tablespace. If the corresponding tablespace does not exist or is too small, the objects are created in the original tablespaces.