Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Undo after drop table...
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. Received on Mon Nov 28 2005 - 17:56:42 CST
![]() |
![]() |