As others have said, it's probably because on Windows you sometimes have to wait a few minutes.
I did want to mention that this statment:
select * from v$datafile where name = 'DATA14.DBF';
seems wrong to me, since the name column in v$datafile usually contains the path along with the filename, and running such a query might cause you to believe a file named data14.dbf is not one of your datafiles when in fact it is (preceded by the directory path.)
> -----Original Message-----
> From: Prem Khanna J [mailto:[EMAIL PROTECTED]]
>
> SQL> drop tablespace DATA14 including contents;
> Tablespace dropped.
>
> the name of the datafile in DATA14 tablespace is DATA141.DBF
>
> SQL>select * from v$tablespace where name = 'DATA14';
> no rows selected
>
> SQL>select * from v$tdatafile where name = 'DATA14.DBF';
> no rows selected
>
> when i try to delete the file DATA14.DBF from o/s , it says :
> "Cannot delete DATA14. There has been a sharing violation.The
> source or destination file may be in use."
>
> why is it so ? how can i delete the file from O/S ?
> can someone help me ?
>
> the ENV is 8.1.6 / win2k.
