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!

Create View and got error ORA-00942 even all of the based-tables/views have a correct privileges

user625322Apr 14 2020 — edited Apr 15 2020

Oracle RDBMS version 12.1.0.2.0

Create a view and get error "ORA-00942: table or view does not exist" despite the fact that all based-tables/views do exist, the owner have "SELECT" privileges to all of based-tables/views.

Just wonder if there is a bug associated with it (similar tooracle 10.2.0.4 bug ( "_complex_view_merging"))

Please help.

Many thanks in advance.

Added on Apr 14 2020

#general-database-discussions

6 comments

531 views