Datafile Sharing Violation Windows NT

Hi,

I have dropped a tablespace and it's associated datafiles from within Oracle (i.e. Oracle knows nothing about the datafiles on the drive) proved by the following: -

SQL> alter database datafile
'f:\oracle\oradata\emslive\emscfmirishgreyhound_d01.ora' offline drop;
alter database datafile
'f:\oracle\oradata\emslive\emscfmirishgreyhound_d01.ora' offline drop
*
ERROR at line 1:
ORA-01516: nonexistent log file, datafile or tempfile
'f:\oracle\oradata\emslive\emscfmirishgreyhound_d01.ora'

The database is not production critical so I have re-started the box but NT/2000 still reports a 'Sharing violation' when I try to remove the datafiles.

Am I missing something, is there somewhere else I should be checking within Oracle for the existence of these files?

Thanks in advance

Mark Davey Received on Tue Dec 03 2002 - 17:41:43 CET