Re: Oracle 9i table reorganization

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: 2 Jul 2001 08:37:52 -0700
Message-ID: <9hq4gg02pq1@drn.newsguy.com>

In article <95db656a.0107020532.51d999a6_at_posting.google.com>, tylon_o._willingham_at_gillette.com says...
>
>Oracle has touted a new feature for 9i - true on-line table reorgs.
>I.e. a table that is undergoing inserts/updates/deletes may be reorged.
>Now that 9i is released, does anyone have any information on this feature?

What do you need to know?

It works in a manner similar to an online index rebuild in 8i. The new table with the modifications is built off to the side, changes to the base table are recorded as we build the modified table. At the end, the changes are synced up and the old/new tables are "swapped". It is performed via stored procedure calls.

Very similar to the online index rebuild architecturally.

--
Thomas Kyte (tkyte@us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp

Received on Mon Jul 02 2001 - 10:37:52 CDT