SYNC_INTERIM_TABLE Procedure

This procedure keeps the interim table synchronized with the original table. This step is useful in minimizing the amount of synchronization needed to be done by finish_reorg_table before completing the online reorganization. This procedure can be called between long running operations (such as create index) on the interim table to sync it up with the data in the original table and speed up subsequent operations.

Syntax

DBMS_REDFINITION.sync_interim_table (

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

Parameters

Table 45-5 SYNC_INTERIM_TABLE Procedure Parameters

Parameter	Description
uname	The schema name of the table.
orig_table	The name of the table to be reorganized.
int_table	The name of the interim table.