RE: tablespace corrupted and no backup , how to remove it ?

From: Christopher Spence <cspence_at_FuelSpot.com>
Date: Tue, 04 Sep 2001 04:30:40 -0700
Message-ID: <F001.0038171F.20010904043621@fatcity.com>

Oracle
guarentees consistency, how can that be forced if parts of the database are allowed to lag behind.
 
 
"Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes."
Christopher R. Spence <FONT

face="Comic Sans MS" size=2>Oracle DBA <FONT face="Comic Sans MS" 
size=2>Phone: (978) 322-5744 <FONT face="Comic Sans MS" 
size=2>Fax:    (707) 885-2275 

Fuelspot <FONT

face="Comic Sans MS" size=2>73 Princeton Street <FONT 
face="Comic Sans MS" size=2>North, Chelmsford 01863 <FONT 
face="Comic Sans MS" size=2>  

  

<FONT

  face=Tahoma size=2>-----Original Message-----From: Maya Kenner   [mailto:maya.kenner_at_trema.com] Sent: Monday, September 03, 2001   10:10 AMTo: Multiple recipients of list ORACLE-LSubject:   tablespace corrupted and no backup , how to remove it ?
<SPAN

  class=514350113-03092001>Hello,
<SPAN

  class=514350113-03092001> 
  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.
<SPAN

  class=514350113-03092001> 
  Any idea how
  to?
<SPAN

  class=514350113-03092001> 
<SPAN

  class=514350113-03092001>Thanks,
<SPAN

  class=514350113-03092001>Maya Received on Tue Sep 04 2001 - 06:30:40 CDT