assistance dropping lost tablespace, contains partitioned tables
- From: "George Leonard" <leonarge@xxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 22 Apr 2004 13:07:08 +0200
Hi all
Scenario
We lost a set of discs, they were only being used as a scratch pad and
contained no production data.
About 10 tablespace was located on the disc.
The tablespace had in them partitioned tables by list and then sub
portioned by hash.
I am having problems dropping the tablespaces including contents since
it picks up that it is a partitioned table that contains segments in
other tablespaces.
I have tried dropping the user with cascade but this tries to access the
actual datafiles which is of course not reachable.
George
=20
________________________________________________
=20
George Leonard
Oracle Database Administrator
Dimension Data (Pty) Ltd
(Reg. No. 1987/006597/07)
Tel: (+27 11) 575 0573
Fax: (+27 11) 576 0573
E-mail:george.leonard@xxxxxxxxxxxxx
Web: http://www.didata.co.za
=20
You Have The Obligation to Inform One Honestly of the risk, And As a
Person
You Are Committed to Educate Yourself to the Total Risk In Any Activity!
Once Informed & Totally Aware of the Risk,=20
Every Fool Has the Right to Kill or Injure Themselves as They See Fit!
=93This e-mail is sent on the Terms and Conditions that can be accessed b=
y Clicking on this link http://www.vodacom.net/legal/email.asp "
----------------------------------------------------------------
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:
