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 -> Re: Cleanup tablespace after deleting the dbf file!

Re: Cleanup tablespace after deleting the dbf file!

From: NetComrade <andreyNSPAM_at_bookexchange.net>
Date: Mon, 13 May 2002 17:34:03 GMT
Message-ID: <3cdff8f8.6637764@news.globix.com> 





offlie drop of a file might help..


then drop tablespace


On 6 May 2002 12:15:26 -0700, sathya_narayan_at_hotmail.com (Sathya)
wrote:



>Hi,

>I erroneously deleted the dbf file of a tablespace.

>Now, I am unable to create or delete that particular tablespace.

>

>Anyway to cleanup?

>

>Sathya




.......


We use Oracle 8.1.7.3 on Solaris 2.7 boxes
remove NSPAM to email
Received on Mon May 13 2002 - 12:34:03 CDT












Original text of this message













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