Skip to Main Content

Oracle Database Discussions

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 has errors

DavidNilsFeb 16 2011 — edited Feb 16 2011
Hello,

I'm trying to create a view but gets the following error/warning: ORA-04063 View XXXXX has errors.

I have googled a bit and it seams that this error ocurrs when something that is inaccessible or non existans is referenced in the view query. However, the query executes fine when i run it in a query windows in Oracle SQL Developer.

I'm Using 10g.

Any ideas? Can it be that I need a perticular grant in order to run a query in a view?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 16 2011
Added on Feb 16 2011
8 comments
74,735 views