Wednesday, August 12, 2015

Oracle Troubleshoot: code, arguments: [25027], [TS#],

Updating a table causing the following error. Dropping and recreating the table fixed the issue. Do this only if the table is not a critical table. The tablespace # 29 was the culprit. Seen this the 3rd time this year. They all fixed the same way.

SQL state [60000]; error code 
[600]; ORA-00600: internal error code, arguments: [25027], [29], [0], [], 
[], [], [], [], [], [], [], [] 
; nested exception is java.sql.SQLException: ORA-00600: internal error 
code, arguments: [25027], [29], [0], [], [], [], [], [], [], [], [], [] 

Resolution: Doc ID 1608861.1.

Summary of the Oracle note
The error is fixed by:
recreating the table using exp-drop-import.
OR
Move the lob in a new tablespace.
Alter table <name> move lob(&lob_column) store as (tablespace &tbsp);

No comments:

Post a Comment