START_REDEF_TABLE Procedure

This procedure initiates the reorganization process. After verifying that the table can be reorganized online, you create an empty interim table (in the same schema as the table to be reorganized) with the desired attributes of the post-reorganization table.

Syntax

DBMS_REDINITION.start_redef_table (

uname  IN VARCHAR2,
orig_table  IN VARCHAR2,
int_table  IN VARCHAR2,
col_mapping  IN VARCHAR2 := NULL);

Parameters

Table 45-3 START_REDEF_TABLE Procedure Parameters

Parameter	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.
col_mapping	The mapping information from the columns in the interim table to the columns in the original table. (This is similar to the column list on the SELECT clause of a query.) If NULL, all the columns in the original table are selected and have the same name after reorganization.