insert是遭遇到ORA-26040: Data block was loaded using the NOLOGGING option

测试的时候遇到，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
---------------------------------------------------------------------

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/8242091/viewspace-672491/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/8242091/viewspace-672491/