00600 Exception Solution: ORA-00600: Internal error code, parameters: [19004], [], [], [], [], []

< problem description >

This problem exists with all platforms in ORACLE 10.1 OR 10.2.

< problems >
Occurs when multiple tables are associated with complex queries
ORA-00600: Internal error code, parameters: [19004], [], [], [], [], [], [], [] Error

< solutions >
This is an Oracle bug.

Treatment Option 1:
EXECUTE AS DBA:
Execute dbms_stats.delete_schema_stats (' zlhis ');

Treatment Option 2:
If only an error occurred in the query for an individual table, you can only handle the error table.
Execute dbms_stats.delete_table_stats (' zlhis ', ' patient expense record ');

Note:

"Zlhis" is the Oracle user of the table to which you have the error.

"Patient expense Record" is the Zlhis user's table name.

With the above method, you can delete the Error object and recreate it. (You cannot delete an object without deleting statistics)