oracle 表空间删除不了，导致create,grant等命令执行失败。
最近oracle遇到一个问题，找不到方法，求大神帮忙解决:oracle的一个表空间一直在使用状态，删不掉~~导致 oracle 使用grant , create 等命令失败。
将表空间offline 后执行drop语句，错误提示跟原来一样。。。
求各路高手帮忙分析下。。
错误如下：
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-00376: file 9 cannot be read at this time
ORA-01110: data file 9: '/home/oracle/app/oracle/oradata/orcl/tabogg.dbf'
ORA-06512: at line 999
ORA-00376: file 9 cannot be read at this time
ORA-01110: data file 9: '/home/oracle/app/oracle/oradata/orcl/tabogg.dbf'
尝试将表空间,offline,然后drop但是还是报以上错误。
select file#,ts#,name from v$datafile;
9 9 '/home/oracle/app/oracle/oradata/orcl/tabogg.dbf'
alter database datafile 9 offline drop;
执行drop 提示 表空间已经offline,然后执行
drop tablespace tabogg including contents and datafiles;
但错误提示还是：
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-00376: file 9 cannot be read at this time
ORA-01110: data file 9: '/home/oracle/app/oracle/oradata/orcl/tabogg.dbf'
ORA-06512: at line 999
ORA-00376: file 9 cannot be read at this time
ORA-01110: data file 9: '/home/oracle/app/oracle/oradata/orcl/tabogg.dbf'
页:
[1]