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?
As i know :
alter tablespace ... offline;
has to write to this tablespace :
1) all uncommited transactions
2) checkpoint number in datafile header block for each file in the tablespace.
in this situation this command can't solve this problem.
>>> alter database datafile 'missing XXXXXX' offline drop
may solve this problem in noachivelog mode only if no one oracle objects or espesially
part of object like tables, indexes ... no place in this datafile.but in any way in archivelog
mode oracle will ignore drop clause.