Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Undo after drop table...
"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 2005Received on Fri Nov 25 2005 - 06:30:34 CST