Complete recovery

From: David Pintor <>
Date: Thu, 2 Jul 2009 10:47:54 +0100
Message-ID: <>

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.


Received on Thu Jul 02 2009 - 04:47:54 CDT

Original text of this message