I will like to create a materialized view on a schema tr which has select grant on a table cars on a different schema src
I used the following statement
CREATE MATERIALIZED VIEW tr.cars_mv
WITH PRIMARY KEY
I am having the following error:
ora-00942: table or view does not exist
I have done the following checks
• the spelling of the table or view name.
• that a view is not specified where a table is required.
• that an existing table or view name exists.
In fact if I run the query under tr it functions that is without the create materialized view statement
What could be the source of the error. Could it be related to the characteristics of the materialized view ( REFRESH FAST ) to be created