11、Oracle错误:database not openqueries allowed on fixed tablesviews only

Oracle错误:database not openqueries allowed on fixed tablesviews only

dba用户无法对数据库进行查询操作

1、查找阻塞的文件

SQL>alter database open;

2、执行删除操作

SQL>alter database datafile '/u01/app/oracle/product/11.2.0/db_1/dbs/C:ORACLEPRODUCT11.2.0DBHOME_1ORADATACOSTCTL3COSTCTL_TBS.DBF' offline drop;

3、再次执行不会再报错为成功

SQL>alter database open;
posted @ 2022-09-14 17:57  站着说话不腰疼  阅读(238)  评论(0)    收藏  举报