I have a complicated query which does some partition by and uses couple pivot clauses. Also references tables from other schema. And it all works fine.
Then I created a view using the query. View does get successfully created and user_objects does show that too.
But select * from that view gives error that the table or view does not exist.
Any clue? I am on Oracle 11g.
It will be difficult to put actually query since I don't want to publish real table and column names, but if that is a must,
I can clean it up and send some outline of the query.
Please advice.
Regards,
RN