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: Mladen Gogala <gogala_at_sbcglobal.net>
Date: Sat, 26 Nov 2005 20:09:25 GMT
Message-Id: <pan.2005.11.26.20.09.25.722637@sbcglobal.net>


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.

-- 
http://www.mgogala.com
Received on Sat Nov 26 2005 - 14:09:25 CST

Original text of this message

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