Loading...
Thursday, May 8, 2008

ORA-00600

ORA-00600
ORA-00600: internal error code, arguments: [number], [number], [], [], [], []
Cause: Process has encountered Oracle internal exceptions, The message text can be followed by up to six arguments, which indicate the origin and attributes of the error. The first argument is the internal error number. Other arguments are various numbers, names, and character strings arguments are various numbers, names, and character strings and attributes of the error
Action: Find the solution for matched arguments number below, if not found report as a bug - the first argument is the internal error number



ORA-00600-19004
ORA-00600-19004: ORA-00600: internal error code, arguments: [19004],
Cause: normally this error argument would be found while querying table or view. Try the following solution:
Action: 1. login to oracle (using sqlplus at command line prompt):
sqlplus "username@servicename"

2. enter the following command
sql>ANALYZE TABLE table_name delete statistics;
Note: Incase of view try apply the command with each table forming the view.


Tags: , , , ,

0 comments:

 
TOP