U R on windows OS I guessOriginally posted by abhaysk
This sounds almost impossible.....
When the tablespace is online it would have obiviously locked all its datafiles....& when file is locked at OS level you just cant delete/rename/move the file.
I wonder how on earth ( may it be any OS ) lets you delete file when locked?
Can any one tell how this can be done...Tried to simulate the problem but it seems almost impossible.