ORA-04063 table has errors
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: ORA-04063 table has errors

  1. #1
    Join Date
    Jul 2004

    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 my database 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....

  2. #2
    Join Date
    Aug 2002
    Colorado Springs
    There's some patch scripts available on metalink for this ...
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

Posting Permissions

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

Click Here to Expand Forum to Full Width