Oracle9i Supplied PL/SQL Packages and Types Reference Release 1 (9.0.1) Part Number A89852-02 |
|
DBMS_REDEFINITION , 4 of 6
This procedure completes the reorganization process. Before this step, you can create new indexes, triggers, grants, and constraints on the interim table. The referential constraints involving the interim table must be disabled. After completing this step, the original table is reorganized with the attributes and data of the interim table. The original table is locked briefly during this procedure.
DBMS_REDFINITION.finish_redef_table (uname IN VARCHAR2, orig_table IN VARCHAR2, int_table IN VARCHAR2);
Parameters | Description |
---|---|
uname |
The schema name of the tables. |
orig_table |
The name of the table to be reorganized. |
int_table |
The name of the interim table. |
|
![]() Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|