Re: inserts during table move

From: Howard J. Rogers <howardjr_at_www.com>
Date: Tue, 30 Oct 2001 17:20:59 +1100
Message-ID: <3bde4739$0$21541$afc38c87@news.optusnet.com.au>

But they do!

9i allows on-line table redefinitions. The process isn't pretty, and involves elaborate calls to the dbms_redefinition package that tax my syntactical skills to the limit, but it works.

How do they pull it off? A journalling table (a materialized view log) stores the DML, and once the redfinition is finished, the journal is applied to the finished product. All spiffingly clever.

Why do it? Because in an OLTP system, having a crucial table locked out for 5, 10 or more minutes whilst an alteration takes place is a big no-no.

Regards
HJR

--

Oracle Resources : http://www.geocities.com/howardjr2000
========================================


"godmann" <allanwtham_at_yahoo.com> wrote in message
news:95cd51c.0110292207.587eccde_at_posting.google.com...


> Hi Eugene,

>

>   Why do you want to insert why a table is being altered? I don't see

> the need for that. Can't you wait until the table is altered then

> do the insert??? And I don't see how Oracle will ever support that!

>

>

> Allan W. Tham

> DBA

Received on Tue Oct 30 2001 - 00:20:59 CST