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 to delete datafile when the database is running on the NT

How to delete datafile when the database is running on the NT

From: Dong Tang <tangd_at_ctcdist.com>
Date: Mon, 8 Feb 1999 15:26:58 -0600
Message-ID: <xJIv2.251$k22.8705@ptah.visi.com>


Hi:

I am running Oracle 8.0 on NT 4.0. I just dropped a tablespace, and I want to delete the datafiles in the tablespace. But I get a sharing violation. It seems database engine still keep those file open even the whole table space was already dropped.

How do I delete datafiles when the database is running?

Thanks

Dong Tang Received on Mon Feb 08 1999 - 15:26:58 CST

Original text of this message

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