Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Block DML!?

Re: Block DML!?

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Fri, 06 Aug 2004 06:51:42 -0700
Message-ID: <1091800341.429221@yasure>


Mark Townsend wrote:

>

>>
>> 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.

The calm, reasoned, well thought out approach. Who asked you. ;-)

Good point!

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)
Received on Fri Aug 06 2004 - 08:51:42 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US