0 Replies Latest reply on Jul 19, 2013 6:34 AM by Ramuplsql10

    ORA-04063: view "SYS.ALL_QUEUE_TABLES" has errors

    Ramuplsql10

      Hi,

       

      can any one help on this..while Iam exporting (Tools-> db export)the db in Oracle sql developer it doesn't show the db objects also.

       

      fyi,  What ever my packages procedures views are compiled and executed  successfully,Please help me

       

       

      An error was encountered performing the requested operation:


      ORA-04063: view "SYS.ALL_QUEUE_TABLES" has errors

      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.

      Vendor code 4063