Oracle in a Nutshell

Calls

PROCEDURE DBMS_REDEFINITION.CAN_REDEF_TABLE (uname IN VARCHAR2, tname IN VARCHAR2, options_flag IN BINARY_INTEGER := 1);

If the uname.tname table cannot be redefined with options_flag of either DBMS_REDEFINITION.CONS_USE_PK (redefinition done using primary key, the default) or DBMS_REDEFINITION.CONS_USE_ROWID (redefinition done using ROWID), an error is returned.

PROCEDURE DBMS_REDEFINITION.START_REDEF_TABLE (uname IN VARCHAR2, orig_table IN VARCHAR2, int_table IN VARCHAR2, col_mapping IN VARCHAR2:= NULL, options_flag IN BINARY_INTEGER := 1);

Starts redefinition of uname.orig_table into interim table int_table with col_mapping list. If col_mapping is NULL, all columns of orig_table are used. options_flag has the same value as for CAN_REDEF_TABLE.

PROCEDURE DBMS_REDEFINITION.FINISH_REDEF_TABLE (uname IN VARCHAR, orig_table IN VARCHAR2, int_table IN VARCHAR2);

Completes redefinition of uname.orig_table. You can create new indexes, triggers, grants, and constraints on the int_table before this call.

PROCEDURE DBMS_REDEFINITION.SYNCH_REDEF_TABLE (uname IN VARCHAR, orig_table IN VARCHAR2, int_table IN VARCHAR2);

Synchronizes int_table with uname.orig_table. If there is a long-running process, this procedure can reduce the final work performed by FINISH_REDEF_TABLE.

PROCEDURE DBMS_REDEFINITION.ABORT_REDEF_TABLE (uname IN VARCHAR, orig_table IN VARCHAR2, int_table IN VARCHAR2);

Cleans up errors that occur during the redefinition process.