Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Undo after drop table...
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.comReceived on Sat Nov 26 2005 - 14:09:25 CST
![]() |
![]() |