FINISH_REDEF_TABLE Procedure

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.

Syntax

DBMS_REDFINITION.finish_redef_table (

uname  IN VARCHAR2,
orig_table  IN VARCHAR2,
int_table  IN VARCHAR2);

Parameters

Table 45-4 FINISH_REDEF_TABLE Procedure Parameters

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.