Kom på arbejde her til morgen, og fandt nedenstående Oracle 600 fejl i min mail box. Miljøet er SUN 9 og databaserne er 10.2.0.2. Jeg havde siddet og trukket nogle data ud i går aftes fra DBA_TYPES og DBA_OBJECTS. Nedenstående er mit SQL script der producere denne 600 fejl.
2 t.attributes,
3 t.methods
4 from SYS.DBA_TYPES t, SYS.DBA_OBJECTS o
5 where o.owner = 'SYSTEM'
6 and o.owner = t.owner
7 and o.object_type = 'TYPE'
8 and o.object_name = t.type_name
9* and o.subobject_name is null
SQL> /
from SYS.DBA_TYPES t, SYS.DBA_OBJECTS o
*
ERROR at line 4:
ORA-00600: internal error code, arguments: [15160], [], [], [], [], [], [], []
2 t.attributes,
3 t.methods
4 from SYS.DBA_OBJECTS o, SYS.DBA_TYPES t
5 where o.owner = 'SYSTEM'
6 and o.owner = t.owner
7 and o.object_type = 'TYPE'
8 and o.object_name = t.type_name
9* and o.subobject_name is null
SQL> /
--------------------------------------------------------------------------------
OBJECT_TYPE STATUS TYPECODE ATTRIBUTES METHODS
------------------- ------- ------------------------------ ---------- ----------
REPCAT$_OBJECT_NULL_VECTOR
TYPE VALID OBJECT 4 0
Altså der byttes om på FROM sætningen fra SYS.DBA_TYPES t, SYS.DBA_OBJECTS o, til SYS.DBA_OBJECTS o, SYS.DBA_TYPES t. Og dette er altså W.A på denne ! Nedenfor Metalink forklaring på denne fejl.
PURPOSE:
This article discusses the internal error "ORA-600 [15160]", what it means and possible actions. The information here is only applicable to the versions listed and is provided only for guidance.
ERROR:
ORA-600 [15160]
VERSIONS:
versions 7.0 to 10.1
DESCRIPTION:
We are attempting to find a suitable table as the starting point in a complex join operation.This error is reported when a suitable table can not be indentified.
FUNCTIONALITY:
Kernel Kompile Optimizer
IMPACT:
PROCESS FAILURE
NON CORRUPTIVE - No underlying data corruption.
SUGGESTIONS:
If the Known Issues section below does not help in terms of identifying a solution, please submit the trace files and alert.log to Oracle Support Services for further analysis.