RE: assistance dropping lost tablespace, contains partitioned tables
- From: "Mohan, Ross" <RMohan@xxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 22 Apr 2004 10:21:13 -0400
Had the (unpleasant) opportunity to do this recently on 817, as described,
and
it did, in fact, work for me. YMMV.
-----Original Message-----
From: Jonathan Lewis [mailto:jonathan@xxxxxxxxxxxxxxxxxx]
Sent: Thu 4/22/2004 12:20 PM
To: oracle-l@xxxxxxxxxxxxx
Cc:
Subject: Re: assistance dropping lost tablespace, contains partitioned
tables
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 <http://www.jlcomp.demon.co.uk>
The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
<http://www.jlcomp.demon.co.uk/faq/ind_faq.html>
April 2004 Iceland http://www.index.is/oracleday.php
<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
<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/
<//www.freelists.org/archives/oracle-l/>
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
<//www.freelists.org/help/fom-serve/cache/1.html>
-----------------------------------------------------------------
-- Binary/unsupported file stripped by Ecartis --
-- Type: application/ms-tnef
----------------------------------------------------------------
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
-----------------------------------------------------------------
Other related posts:
