dBEGIN dbms_mview.refresh('TUSER.USER_BC'); END;
ERROR at line 1:
ORA-12008: error in materialized view refresh path
ORA-00600: internal error code, arguments: [ktbesc_plugged], , , , ,
, , , , , , 
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2563
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2776
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2745
ORA-06512: at line 1
经MOS查询是由于bug造成，以下是mos上的解决方案，我在此采用的是move tablspace 但长久的方法是apply one-off Patch:12919564！
This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
Oracle Server - Enterprise Edition - Version: 126.96.36.199 to 188.8.131.52 - Release: 11.2 to 11.2
This problem can occur on any platform.
Receiving the following error on insert or delete against one particular table.
ORA-00600: internal error code, arguments: [ktbesc_plugged], , , , , , , , , , , 
Call Stack Trace = ktbesc -> kdiescpin -> kdifind -> kdiblTestPrefixUniqueness -> kdiblLockPiece -> kdiblLockRange
Table is located on a recently plugged in tablespace into an 184.108.40.206 database.
Bug:12919564 where this problem was introduced in 220.127.116.11.
We successfully used a temporary workaround of moving the problem table to another tablespace. Once moved, we were able to insert or delete without issue.
alter table <table name> move tablespace <tablespace name>;
There is an additional workaround of setting "_fastpin_enable"=0 which is discussed in Document 12919564.8. Long term resolution would be to apply one-off Patch:12919564.
来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/26390465/viewspace-1793126/，如需转载，请注明出处，否则将追究法律责任。