Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

Ramuplsql10Jul 19 2013

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

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Aug 16 2013
Added on Jul 19 2013
0 comments
1,554 views