Calls
-
PROCEDURE DBMS_REDEFINITION.CAN_REDEF_TABLE(unameIN VARCHAR2,tnameIN VARCHAR2,options_flagIN 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(unameIN VARCHAR2,orig_tableIN VARCHAR2,int_tableIN VARCHAR2,col_mappingIN VARCHAR2:= NULL,options_flagIN 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(unameIN VARCHAR,orig_tableIN VARCHAR2,int_tableIN 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(unameIN VARCHAR,orig_tableIN VARCHAR2,int_tableIN 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(unameIN VARCHAR,orig_tableIN VARCHAR2,int_tableIN VARCHAR2); Cleans up errors that occur during the redefinition process.