Oracle9i Supplied PL/SQL Packages and Types Reference Release 1 (9.0.1) Part Number A89852-02 |
|
DBMS_REDEFINITION , 5 of 6
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.
DBMS_REDFINITION.sync_interim_table (uname IN VARCHAR2, orig_table IN VARCHAR2, int_table IN VARCHAR2);
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. |
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|