September 24, 2007
September 19, 2007
An attempt to create a materialized view fails if the master object is a remote view.
The error is ORA-00942, table or view does not exist.
This happens when the remote view is not owned by the database link user. In my case:
create database link demo_db_link connect to MVADMIN identified by MVADMIN