hi,Jonathan Lewis > I was a little surprised (and relieved) at the way I could >change data dictionary definitions even when the objects >referenced were in destroyed data files oh,it seems that oracle only change the data_object_id ,even= not check the segment header :) Best regards yahoo id: feng_chunpei A new dba from china ---- from the mail----- >I haven't tested this idea, but it might work. > > Identify the partitions that are in the lost datafiles. > > Create empty tables of the same structure in > some on-line files. > > For each problem partition, exchange the partition > with one of the new tables. > >The lost datafiles now contain nothing but simple tables >so you should be able to drop the tablespace. > >I know I did something like this once when I was testing >disaster recovery scenarios with partitioned tables in 8.1.6, >and I was a little surprised (and relieved) at the way I could >change data dictionary definitions even when the objects >referenced were in destroyed data files. > >Regards > >Jonathan Lewis >http://www.jlcomp.demon.co.uk > >The Co-operative Oracle Users' FAQ >http://www.jlcomp.demon.co.uk/faq/ind_faq.html > >April 2004 Iceland http://www.index.is/oracleday.php >June 2004 UK - Optimising Oracle Seminar >July 2004 USA West Coast, Optimising Oracle Seminar >August 2004 Charlotte NC, Optimising Oracle Seminar >September 2004 USA East Coast, Optimising Oracle Seminar >September2004 UK - Optimising Oracle Seminar > > >----------------------------------------------------------------= >Please see the official ORACLE-L FAQ: http://www.orafaq.com >----------------------------------------------------------------= >To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx >put 'unsubscribe' in the subject line. >-- >Archives are at //www.freelists.org/archives/oracle-l/ >FAQ is at //www.freelists.org/help/fom-serve/cache/1.html >----------------------------------------------------------------= - > >. =A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1 ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------