I know you are asking about Recovery. But is the RECYCLE BIN in use on this database? If so, look into the FLASHBACK DROP feature. This is exactly why I like the recyclebin . "FLASHBACK TABLE <table_name> TO BEFORE DROP;' -- simple version of it, depending on what is in the recyclebin. Bradd Piontek "Next to doing a good job yourself, the greatest joy is in having someone else do a first-class job under your direction." -- William Feather On Thu, Jul 2, 2009 at 4:47 AM, David Pintor <painterman@xxxxxxxxx> wrote: > Hi guys, > > ** Oracle 10.2 on Solaris 10 box. > > Someone removed a user table this morning. I have a cold backup from last > night. I want to restore just the USERS tablespace (where the table was) and > perform a complete recovery. Is that possible? I've tried recovering the > datafile by stopping the database, copying the datafile manually, and then > doing a recover database. The recover is complete but my table is still > missing... what am I doing wrong? > > Thanks for your help. > > David >