因为表空间不足,我增加了一个数据文件,因为忘指定所属
的表空间,所以用alter database datafile '...../*.dbf' offline drop;
想删掉该文件,但是在数据字典里仍然存在,online_status的状态为:recover.
该如何删除呢。。谢谢!
的表空间,所以用alter database datafile '...../*.dbf' offline drop;
想删掉该文件,但是在数据字典里仍然存在,online_status的状态为:recover.
该如何删除呢。。谢谢!
原文:
DROP
If the database is in NOARCHIVELOG mode, you must specify the DROP clause to take a datafile offline. However, the DROP clause does not remove the datafile from the database. To do that, you must drop the tablespace in which the datafile resides. Until you do so, the datafile remains in the data dictionary with the status RECOVER or OFFLINE. If the database is in ARCHIVELOG mode, Oracle ignores the DROP keyword.
sqlplus "/ as sysdba"
查看归档模式
archive log list
alter database achivelog;
alter database datafile '...../*.dbf' online drop;