This is [hugely] not my area, but is TSPITR a possible option?
Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Hotsos Clinic 101 in Reykjavik, Ottawa, Dallas, Washington, Denver, Sydney - Visit www.hotsos.com for schedule details... -----Original Message----- Faroult Sent: Monday, June 02, 2003 7:39 AM To: Multiple recipients of list ORACLE-L 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Cary Millsap 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).
