Problém
Wed May 03 18:00:23 2017 Errors in file /oracle/oraORCL/diag/rdbms/ORCL/ORCL/trace/ORCL_ora_9395.trc (incident=674711): ORA-00600: kód vnitřní chyby, argumenty: [25027], [10], [0], [], [], [], [], [], [], [], [], [] Use ADRCI or Support Workbench to package the incident. See Note 411.1 at My Oracle Support for error and packaging details.
Řešení
podle ORA-00600 [25027] [x] [0] Raised by Insert into LOB (Doc ID 1608861.1)
SYS@ORCL> exec DBMS_SPACE_ADMIN.ASSM_SEGMENT_VERIFY('SPS','EPDZ_COMPONENT','TABLE',null,DBMS_SPACE_ADMIN.SEGMENT_VERIFY_SPECIFIC,DBMS_SPACE_ADMIN.BITMAPS_CHECK);
Procedura PL/SQL uspesne dokoncena.
Důležité:
Note that if DBMS_SPACE_ADMIN.ASSM_SEGMENT_VERIFY does not report any errors, it does not mean that the problem is not there.
The error is fixed by:
recreating the table using exp-drop-import.
OR
Move the lob in a new tablespace.
Alter table move lob(&lob_column) store as (tablespace &tbsp);