Skip to Main Content
Oracle in a Nutshell
book

Oracle in a Nutshell

by Rick Greenwald, David C. Kreines
December 2002
Intermediate to advanced content levelIntermediate to advanced
928 pages
85h 29m
English
O'Reilly Media, Inc.
Content preview from 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.

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Oracle Internals

Oracle Internals

Donald K. Burleson
Oracle PL/SQL

Oracle PL/SQL

Lewis Cunningham
Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Rick Greenwald, Robert Stackowiak, Jonathan Stern

Publisher Resources

ISBN: 0596003366Errata Page