首页 > 数据库 > oracle > 正文

oracle 删除表空间 failed verification check wrong creation SCN
2018-05-31 15:19:00 点击:

删除表空间报错:ERROR at line 1:ORA-01122: database file 6 failed verification checkORA-01110: data file 6: & 39; dat

删除表空间报错:

ERROR at line 1:
ORA-01122: database file 6 failed verification check
ORA-01110: data file 6: '/data/oracle/oradata/xe/admindb01.dbf'
ORA-01203: wrong incarnation of this file - wrong creation SCN



解决方法,先离线数据库再删除:

alter database datafile '/data/oracle/oradata/xe/admindb01.dbf' offline drop;


相关热词搜索:空间 oracle

上一篇:oracle建立只读用户
下一篇:plsql连接oracle设置教程