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: DA Morgan <damorgan_at_psoug.org>
Date: Mon, 28 Nov 2005 18:38:34 -0800
Message-ID: <1133231908.667270@jetspin.drizzle.com>


William Robertson wrote:

> Mladen Gogala wrote:
> 

>>On Fri, 25 Nov 2005 03:54:08 -0800, cartoedm wrote:
>>
>>
>>>I've commited a drop on a table but this was an accident ! I don't know
>>>if it's possible to undo this action ? How to restore my table. I need
>>>help, thanks a lot.
>>
>>Get it back from the recycle bin like this:
>>
>>FLASHBACK TABLE <table name> TO BEFORE DROP;
>>
>>No problem whatsoever.
> 
> 
> It would be no problem whatsoever if the OP had 10g, or a backup.

dbms_flashback does essentially the same thing in 9i.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Mon Nov 28 2005 - 20:38:34 CST

Original text of this message

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