From oracle-l-bounce@freelists.org Thu Apr 22 06:51:57 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i3MBpv214555 for ; Thu, 22 Apr 2004 06:51:57 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i3MBpu614550 for ; Thu, 22 Apr 2004 06:51:56 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id B1EAE72CB94; Thu, 22 Apr 2004 06:45:05 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 09136-74; Thu, 22 Apr 2004 06:45:05 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id EA8A172CBFB; Thu, 22 Apr 2004 06:45:04 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Thu, 22 Apr 2004 06:43:53 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id ECF8E72CBF5 for ; Thu, 22 Apr 2004 06:43:52 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 08649-64 for ; Thu, 22 Apr 2004 06:43:52 -0500 (EST) Received: from jands2.bayer.com (host250.bayer.com [192.122.250.250]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 8F78C72CBF1 for ; Thu, 22 Apr 2004 06:43:52 -0500 (EST) Subject: Re: assistance dropping lost tablespace, contains partitioned tables To: oracle-l@freelists.org Message-ID: From: Michael Boligan Date: Thu, 22 Apr 2004 07:55:29 -0400 MIME-Version: 1.0 Content-type: text/plain; charset=US-ASCII X-Virus-Scanned: by amavisd-new at freelists.org Content-Transfer-Encoding: 8bit X-archive-position: 3548 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: michael.boligan.b@bayer.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org You can try alter database datafile offline drop; At that point you should be able to drop the TS. HTH, Mike |---------+-----------------------------> | | "George Leonard" | | | | | | Sent by: | | | oracle-l-bounce@fr| | | eelists.org | | | | | | | | | 04/22/2004 07:07 | | | AM | | | Please respond to | | | oracle-l | | | | |---------+-----------------------------> >-----------------------------------------------------------------------------------------------------------------------| | | | To: | | cc: | | Subject: assistance dropping lost tablespace, contains partitioned tables | >-----------------------------------------------------------------------------------------------------------------------| 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@za.didata.com 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@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 ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@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 -----------------------------------------------------------------