Re: Block DML!?

From: Mark Townsend <markbtownsend_at_comcast.net>
Date: Fri, 06 Aug 2004 06:09:29 GMT
Message-ID: <41132098.7060500@comcast.net>

>
> Just to add my tuppence-worth: the suggestion to use dbms_redefinition is
> inappropriate for your purposes, since you want to insert into a new, empty
> table, not to have the existing table be redefined but with all its existing
> records still extant (which is what dbms_redefinition will get you).
>

Well - I did ask why he/she needed a new empty table to insert in. I think we should reserve comment on the appropriateness of redefinition until we find out how we got here in the first place.

The other option is potentially quiese database (subject to some restrictions) but I'd still like to know what the actual problem is. Received on Fri Aug 06 2004 - 01:09:29 CDT