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
