Dropping Tablespaces with missing datafiles
Does anyone know how i can drop a tablespace when the actual data file assocaited with that tablespace is no longer there. Somehow the data file has been deleted but the tablespace still exists. When i use the normal drop command says it can't access the data file.
I have seen this being done before when someone used SVRMGRL command and dropped the tablespace through there but can't wuite remeber how they did it any clues anyone?
Re: Dropping Tablespaces with missing datafiles
This sounds almost impossible.....
Originally posted by hummy
Somehow the data file has been deleted but the tablespace still exists. When i use the normal drop command says it can't access the data file.
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.