Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2004
    Posts
    4

    Exclamation Unanswered: ORA-04063 : table has errors

    Hello,
    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....
    THANKS

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •