Dictionary inconsistency caused by CTAS in PARALLEL

Dictionary inconsistency caused by CTAS in PARALLEL using 10.2.0.4.0 / 11.1.0.7 with several ORA-600 errors [ID 784633.1]  

--------------------------------------------------------------------------------
 
  修改時間 22-JAN-2010     型別 ALERT     狀態 PUBLISHED  

In this Document
  Description
  Likelihood of Occurrence
  Possible Symptoms
  Workaround or Resolution
  Patches
  Modification History
  References

 

--------------------------------------------------------------------------------

 

Applies to:
Oracle Server - Enterprise Edition - Version: 10.2.0.4 to 11.1.0.7 - Release: to 11.1
Oracle Server - Standard Edition - Version: 10.2.0.4 to 11.1.0.7 - Release: to 11.1
Information in this document applies to any platform.

Description
This alert describes the problems referenced in NOTE 7190270.8 and NOTE 7263842.8

Likelihood of Occurrence
Oracle Database Patchset 10.2.0.4.0 / 11.1.0.7 are installed and "Create Table as Select" (CTAS) in PARALLEL is used.

Possible Symptoms
The script. HCheck, available at Note 136697.1, reports the inconsistencies as:

Problem: Orphaned TAB$ (no SEG$)
Problem: Orphaned Table Partition (no SEG$)

The following internal errors may be produced once this inconsistency is introduced:

ORA-600 [ktssdrp1]
ORA-600 [ktsircinfo_num1]
ORA-600 [25027]
ORA-600 [ktadrprc-1]

They can occur during any DDL or DML like:

DROP TABLE | PURGE;
ALTER TABLE DROP PARTITION ;
PURGE RECYCLEBIN;
ANALYZE TABLE VALIDATE STRUCTURE;
SELECT/INSERT/DELETE/UPDATE/etc

Workaround or Resolution
These problems have been introduced in patchset 10.2.0.4 / 11.1.0.7 by the bugs described in
NOTE  7190270.8  for the Orphaned TAB$ (no SEG$)  case (which applies to 10.2.0.4 ONLY)
and
NOTE 7263842.8 for Orphaned Table Partition (no SEG$) case (which applies to 10.2.0.4 and 11.1.0.7)

Workarounds:

1. Rename the affected table and create a new one.
2. Restore from backup and recover until a point in time before the inconsistencies were introduced.

If further assistance is required please contact Oracle Global Customer Service.

 

Patches
To prevent this data dictionary inconsistency to be introduced, apply the patches Patch 7190270 (10.2.0.4 ONLY) and Patch 7263842 (10.2.0.4 / 11.1.0.7).

Fixes were also included in the PSUs below
Patch 8833297 11.1.0.7.1 Patch Set Update (PSU)
Patch 8833280 10.2.0.4.2 Patch Set Update (PSU)

These one off patches do not fix current inconsistencies.

Modification History
26-MAR-2009 - Published the alert
08-JUL-2009 - Added clarification that Bug 7190270 applies to 10.2.0.4 only and bug 7263842 applies to both 10.2.0.4 and 11.1.0.7
04-JAN-2010 - Added references to PSU
22-JAN-2010 - Fixed references to 10.2.0.4.2 Patch Set Update (PSU)

References
NOTE:136697.1 - "hcheck.sql" script. to check for known problems in Oracle8i, Oracle9i, Oracle10g and Oracle 11g
NOTE:7190270.8 - Bug 7190270 - Various ORA-600 errors / dictionary inconsistency from CTAS / DROP
NOTE:7263842.8 - Bug 7263842 - ORA-955 during CTAS / OERI [ktsircinfo_num1] / dictionary inconsistency for PARTITIONED Tables

 
 
參考文獻：

Dictionary inconsistency caused by CTAS in PARALLEL using 10.2.0.4.0 / 11.1.0.7 with several ORA-600 errors [ID 784633.1]