Originally 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.

U R on windows OS I guess