Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: tablespace corrupted and no backup , how to remove it ?
Well , you are annoyed when you do your best to corrupt a tablespace and you succeed and that you find out you don't know how to recover from this situation :) Sorry to bother with basic question, I am new to Oracle and to the lists.
/Maya
-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Rachel
Carmichael
Sent: Monday, September 03, 2001 6:45 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: tablespace corrupted and no backup , how to remove it ?
Why would you be annoyed that the database doesn't open with a corrupted tablespace? That's what';s SUPPOSED to happen.
okay, we just did this a few days ago but here it is again:
startup mount
alter database datafile '<filename>' offline drop; (repeat this for every
datafile in the tablespace)
alter database open;
drop tablespace <tablespace name> including contents;
that will get rid of the tablespace
>From: "Maya Kenner" <maya.kenner_at_trema.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: tablespace corrupted and no backup , how to remove it ?
>Date: Mon, 03 Sep 2001 06:10:22 -0800
>
>Hello,
>
>I succeed corrupting a tablespace but now I am a little bit annnoyed as my
>db does not want to go in OPEN mode,
>I would like to remove this tablespace but I failed.
>
>Any idea how to?
>
>Thanks,
>Maya
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rachel Carmichael
INET: carmichr_at_hotmail.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).>Wz^r&9,Bm(ک&aɢw zkzfaZ(IǬ9tQ@_|9ӝRjpz jXh'ZqǬXDCTLkaɚXXǧu1,jkr+rrׄ\ Received on Tue Sep 04 2001 - 07:58:47 CDT
![]() |
![]() |