Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Deleting tablespace file on NT
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
![]() |
![]() |