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

Home -> Community -> Usenet -> c.d.o.misc -> Deleting tablespace file on NT

Deleting tablespace file on NT

From: <mail_at_InfoLog.dk>
Date: 4 Feb 1999 10:42:06 GMT
Message-ID: <01be5033$7bfc7790$2c289a0a@apollo>


Hello All
Im am running a SQL+ script that drops a user and his tablespace, deletes the tablespacefile and then recreates the user and tablespace. This script is run from SQL80+.
The physical delete on the file fails. NT says sharing violation. After a couple of minuttes I can manually delete the file. What is the problem? Can i make ORACLE release the file immediatly? Or is NT just slow to release locks on this file? I know for sure no other user have data in or acces to the tablespace.

System: Personal Oracle 8.04, WindowsNT 4 build 1381.

Here is the script:

drop user myuser cascade;

alter tablespace mytb offline;

drop tablespace mytb
  including contents
   cascade constraints;

create tablespace infolog_data datafile 'd:\orant\database\'mytbfile.ORA'

Thanks
Peter Received on Thu Feb 04 1999 - 04:42:06 CST

Original text of this message

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