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.
© Copyright SS64.com 1999-2013
Some rights reserved