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:jprem_at_kssnet.co.jp]
>
> 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.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jacques Kilchoer
INET: Jacques.Kilchoer_at_quest.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Fri Mar 07 2003 - 12:49:05 CST
