SQL & PL/SQL

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!

getting error Ora- ORA-00942 while creating materialized View

User_9XA6OOct 30 2018 — edited Oct 31 2018

Hi,

I have created view "qv_orderload_20" in the 'ams_emp' schema and now I am creating a materialized view on view which is already created in my 'ams_emp' schema:

CREATE MATERIALIZED VIEW AMS_emp.test12345

select * from AMS_emp.qm_orderload_20;

I am getting following error while creating the same:

00942. 00000 - "table or view does not exist"

could you tell me why I am getting this error.

Thanks

Added on Oct 30 2018

#sql-pl-sql

10 comments

3,291 views