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
---------------------------------------------------------------------
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博客 ” ，链接：https://blog.itpub.net/8242091/viewspace-672491/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
