50
DBMS_REDEFINITION

With DBMS_REDEFINITION, you can perform an online redefinition of tables. To achieve this online redefinition, 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 redefined online are as follows:

• Tables that have materialized views and materialized view logs defined on them cannot be redefined online.
• Tables that are materialized view container tables and AQ tables cannot be redefined online.
• The overflow table of an IOT table cannot be redefined online.

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

This chapter discusses the following topics:

• Constants for DBMS_REDEFINITION
• Summary of DBMS_REDEFINITION Subprograms