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: Undo after drop table...

Re: Undo after drop table...

From: Fabrizio Magni <fabrizio.magni_at_mycontinent.com>
Date: Sun, 27 Nov 2005 19:19:51 +0100
Message-ID: <4389f8c8$0$27593$4fafbaef@reader1.news.tin.it>


DA Morgan wrote:
> Mladen Gogala wrote:
>

>> On Fri, 25 Nov 2005 04:51:05 -0800, cartoedm wrote:
>>
>>
>>> My Oracle version is 9i...
>>
>>
>>
>> You're screwed. Happy Thanksgiving.

>
>
> Au contraire: DBMS_FLASHBACK built-in package might do the trick.

Just to learn a new trick: may you clarify how?

I checked the 9i documentation and it states that some DDL (like drop/truncate) on the table invalidates the undo data preventing any flashback.

Regards

-- 
Fabrizio Magni

fabrizio.magni_at_mycontinent.com

replace mycontinent with europe
Received on Sun Nov 27 2005 - 12:19:51 CST

Original text of this message

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