Re: Undo after drop table...

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Fri, 25 Nov 2005 12:30:34 +0000 (UTC)
Message-ID: <dm705a$pbb$1@nwrdmz03.dmz.ncs.ea.ibs-infra.bt.com>

"cartoedm" <cartographie_at_electricitedemayotte.com> wrote in message news:1132919648.374291.266740_at_f14g2000cwb.googlegroups.com...
> 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.
>

If are running 10g, you can use the table flashback option to 'undrop' the table.

If not, you have to restore and recover a backup copy of the database (or as little of it as you can get away with - look up 'tablespace point in time recovery'), export the table from the backup, and import it to the original. (Create as select across database link would also work rather
than exp/imp).

-- 
Regards

Jonathan Lewis

http://www.jlcomp.demon.co.uk/faq/ind_faq.html
The Co-operative Oracle Users' FAQ

http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html
Cost Based Oracle: Fundamentals

http://www.jlcomp.demon.co.uk/appearances.html
Public Appearances - schedule updated 4th Nov 2005

Received on Fri Nov 25 2005 - 06:30:34 CST