Thread: ORA-04063 : table has errors
07-16-04, 05:18 #1Registered User
- Join Date
- Jul 2004
Unanswered: ORA-04063 : table has errors
I'm new to oracle and have problems with it....
I don't know when it happened, but i have problems with the main instance of oracle wich is being terminated and then restarted every 4-5 minutes.
In the log files there is :
Error 4063 in Queue Table QS.QS_ORDERS_SQTAB
kwqitmmsgs: error 604
error 604 detected in background process
OPIRIP: Uncaught error 447. Error stack:
ORA-00447: fatal error in background process
ORA-00604: error occurred at recursive SQL level 1
ORA-04063: table "QS.QS_ORDERS_SQTAB" has errors
The user QS and his tables belong to the tablespace EXAMPLE wich is installed with ORACLE. I tried to delete the table, the user, the tablespace.... none of these is possible : each time i get the message "End of file on communication pipe" or so error (i don't know the correct translation of the french message : fin de fichier sur le canal de communication).
So if you have any idea, let me know....
07-16-04, 10:56 #2Registered User
Provided Answers: 1
- Join Date
- Aug 2003
- Where the Surf Meets the Turf @Del Mar, CA
04063, 00000, "%s has errors"
// *Cause: Attempt to execute a stored procedure or use a view that has
// errors. For stored procedures, the problem could be syntax errors
// or references to other, non-existent procedures. For views,
// the problem could be a reference in the view's defining query to
// a non-existent table.
// Can also be a table which has references to non-existent or
// inaccessible types.
// *Action: Fix the errors and/or create referenced objects as necessary.You can lead some folks to knowledge, but you can not make them think.
The average person thinks he's above average!
For most folks, they don't know, what they don't know.
Good judgement comes from experience. Experience comes from bad judgement.