45
DBMS_REDEFINITION

With DBMS_REDEFINITION, you can perform an online reorganization of tables. To achieve this online reorganization, incrementally maintainable local materialized views are used. Snapshot logs need to be defined on the master tables to support incrementally maintainable materialized views. These logs keep track of the changes to the master tables and are used by the materialized views during refresh synchronization. Restrictions on the tables that can be reorganized online are as follows:

• Tables with no primary keys cannot be reorganized online.

• Tables that have materialized views and materialized view logs defined on them cannot be reorganized online.

• Tables that are materialized view container tables and AQ tables cannot be reorganized online.

• The overflow table of an IOT table cannot be reorganized online.

  See Also: Oracle9i Database Administrator's Guide for more information.

This chapter discusses the following topics:

• Summary of DBMS_REDEFINITION Subprograms

Summary of DBMS_REDEFINITION Subprograms

Table 45-1 DBMS_REDEFINITION Subprograms

Subprogram	Description
"CAN_REDEF_TABLE Procedure"	Determines if a given table can be reorganized online.
"START_REDEF_TABLE Procedure"	Initiates the reorganization process.
"FINISH_REDEF_TABLE Procedure"	Completes the reorganization process.
"SYNC_INTERIM_TABLE Procedure"	Keeps the interim table synchronized with the original table.
"ABORT_REDEF_TABLE Procedure"	Cleans up errors that occur during the reorganization process.