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?

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 16 2011

Added on Feb 16 2011

#general-database-discussions

8 comments

74,768 views