Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> 8i Tablespace removal if someone has deleted the .dbf instead of dropping the tablespace

8i Tablespace removal if someone has deleted the .dbf instead of dropping the tablespace

From: <eric_dewerth_at_my-deja.com>
Date: Wed, 13 Dec 2000 20:25:14 GMT
Message-ID: <918lv0$6ud$1@nnrp1.deja.com> 






I have an 8i dB with several Tablespaces the were deleted by rm
the .dbf instead of removing the tablespace.  It is causing the
Instance not to OPEN...It will MOUNT but not OPEN.  How do I get Oracle
to recognize that the tablespace is gone? How do I remove the
tablespace since there is no .dbf associated with it?



Thanks,


Eric




Sent via Deja.com


http://www.deja.com/
Received on Wed Dec 13 2000 - 14:25:14 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US