Re: assistance dropping lost tablespace, contains partitioned tables

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Thu, 22 Apr 2004 13:20:06 +0100
Message-ID: <00a501c42864$25ac5c70$7102a8c0@Primary>

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_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

Received on Thu Apr 22 2004 - 07:16:38 CDT