ORA-04063 View has errors
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?