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: