PL/SQL Packages DBMS_REDEFINITION

Perform an online reorganization of tables.

Subprocedures:

CAN_REDEF_TABLE    Determine if a given table can be reorganized online. 

START_REDEF_TABLE  Initiate the reorganization process. 

FINISH_REDEF_TABLE Complete the reorganization process. 

SYNC_INTERIM_TABLE Keep the interim table synchronized with the original table. 

ABORT_REDEF_TABLE  Clean up errors that occur during the reorganization process. 

For full documentation of the packaged procedures above see the Oracle Manual:
"Oracle9i Supplied PL/SQL Packages and Types Reference"

or the book Oracle Built in Packages by Steven Feuerstein et al

See "Oracle9i Database Administrator's Guide" for details of how DBMS_REDEFINITION reorganizes a table by using local materialized views.

Related: 


© Copyright SS64.com 1999-2013
Some rights reserved