最近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'

最近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'