Indy, The RMAN tablespace recovery would be the quickest I believe. Why not make some of the partitions read-only if the data is not going to be updated any more. Ron
>>> [EMAIL PROTECTED] 06/02/03 07:19AM >>> 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 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Rogers 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).
