I fear there is not much you can do, short of restoring the backups you fortunately have. Dropping the tablespace invalidates many things, updates the control file, etc. I presume that the tablespace was dropped with the 'including contents' clause, which means that for Oracle the data in it simply no longer belongs to the database. A bit too late for generating what would have allowed you to plug the tablespace back into the database.
>----- ------- Original Message ------- ----- >From: :[EMAIL PROTECTED] >To: [EMAIL PROTECTED] >Sent: Mon, 02 Jun 2003 03:19:38 > >Please Reply Ur Suggestion at the earliest > >One of DBA had dropped the Wrong tablespace for the >PArtitioned table. The >Datafile exist on the system. How to recover the >Tablespace as it contains >crucial data. RMAN backup also available along with >Archive as well as >Correct timing of Dropping the Datafile > > >Thanks Regards, Stephane Faroult Oriole -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
