CAN_REDEF_TABLE Procedure

This procedure determines if a given table can be reorganized online. This is the first step of the online reorganization process. If the table is not a candidate for online redefinition, an error message is raised.

Syntax

DBMS_REDEFINITION.can_redef_table (

uname  IN VARCHAR2,
tname  IN VARCHAR2);

Exceptions

If the table is not a candidate for online reorganization, an error message is raised.

Parameters

Table 45-2 CAN_REDEF_TABLE Procedure Parameters

Parameter	Description
uname	The schema name of the table.
tname	The name of the table to be reorganized.