Re: How to recover a dropped table ?

>>>>> "MJ" == MJ Wood <maryjanewood_at_hotmail.com> writes:

 MJ> Hi, It happened a few day ago that one of our developer
 MJ> "accidentally" dropped a table in our development database(no
 MJ> archive log).  The data in this table (about 100 lines) is not
 MJ> very important so the data was re-created manually.  Anyway, I
 MJ> just wondering how can I recover the data in the dropped table.
 MJ> This table was dropped around 4pm and at 6pm this database was
 MJ> idle.  I think the data was still in the redo log.  How can I
 MJ> rollback the tablespace to a specific time (e.g. 4pm) and the
 MJ> transactions between 4am to 6pm can be preserved?  Or it is just
 MJ> impossible to do so?  Thanks in advance for any input.

Thats easy - restore it from your backups of course!

Tim

-- 
Tim Cross
The e-mail address on this message is FALSE (obviously!). My real e-mail is
to a company in Australia called rapttech and my login is tcross - if you 
really need to send mail, you should be able to work it out!