测试的时候遇到,insert遇到ORA-26040,很奇怪,一般查询的时候才遇到该错误
SQL> create table ctais2.test as select * from dba_segments;
create table ctais2.test as select * from dba_segments
*
ERROR at line 1:
ORA-01578: ORACLE data block corrupted (file # 4, block # 9235)
ORA-01110: data file 4: '/oradata/SOURCE10/users01.dbf'
ORA-26040: Data block was loaded using the NOLOGGING option
使用dba_extents 检查了下,file # 4, block # 9235是空的,奇怪,块竟然不能复用
感觉可能是回收站的问题,因为flashback过这个库,完成后删了些测试表。
purge dba_recyclebin了下,一切就正常了
查了下MOS,没相关的说明
---------------------------------------------------------------------
该结论是错误的
修正见 http://space.itpub.net/8242091/viewspace-673947
---------------------------------------------------------------------
SQL> create table ctais2.test as select * from dba_segments;
create table ctais2.test as select * from dba_segments
*
ERROR at line 1:
ORA-01578: ORACLE data block corrupted (file # 4, block # 9235)
ORA-01110: data file 4: '/oradata/SOURCE10/users01.dbf'
ORA-26040: Data block was loaded using the NOLOGGING option
使用dba_extents 检查了下,file # 4, block # 9235是空的,奇怪,块竟然不能复用
感觉可能是回收站的问题,因为flashback过这个库,完成后删了些测试表。
purge dba_recyclebin了下,一切就正常了
查了下MOS,没相关的说明
---------------------------------------------------------------------
该结论是错误的
修正见 http://space.itpub.net/8242091/viewspace-673947
---------------------------------------------------------------------
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/8242091/viewspace-672491/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/8242091/viewspace-672491/