Tags

I see ORA-00600[17286] when doing truncate of a table. But later came to know this is not the actual cause.

select object_type, count(*) from dba_objects where status=’INVALID’;

ORA-00600 trace shows the current sql was a pl/sql procedure and it shows as invalid.

 

Workaround:

Run utlrp.sql  2 or more times, and seee the status of the reported package/procedure.

Execute the truncate again, this time it should be success.

Refer Metalink: Best Practices for running catalog, catproc, and utlrp script (DOC ID 863312.1)