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 -> How do I delete a tablespace after I deleted the data file by mistake?

How do I delete a tablespace after I deleted the data file by mistake?

From: <junlei_at_my-deja.com>
Date: Thu, 28 Oct 1999 18:45:39 GMT
Message-ID: <7va5ki$8sg$1@nnrp1.deja.com> 





In the process of creating a bunch of tablespaces, I made a mistake with
the initial extent size for some tablespaces.  I decided to delete them.
Then I proceeded to delelte the corresponding datafiles.  That's when I
mistakenly deleted 2 datafiles corresponding to two tablespaces not yet
deleted.  Now, I can't do anything to these two tablespaces, not even to
take them offline.  So I have set the quoto to none on these
tablespaces for the time being.



Does anyone know how I can solve this problem?



Thanks.



Junlei




Sent via Deja.com http://www.deja.com/



Before you buy.
Received on Thu Oct 28 1999 - 13:45:39 CDT












Original text of this message













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