| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: assistance dropping lost tablespace, contains partitioned tab les
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_at_jlcomp.demon.co.uk]
Sent: Thu 4/22/2004 12:20 PM
To: oracle-l_at_freelists.org
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
-- Archives are at http://www.freelists.org/archives/oracle-l/Received on Thu Apr 22 2004 - 09:44:48 CDT
<http://www.freelists.org/archives/oracle-l/>
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
<http://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_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 -----------------------------------------------------------------
 |
 |