MVIEW creation on tables with “OBJECT TYPE”

Posted on by Anand

Recently i faced the below error while creating the materialized view on the target database. ORA-21700:object does not exist or is marked for delete CREATE MATERIALIZED VIEW LAPTEST.USER_MASTER TABLESPACE LAP_MATERIALIZE_VIEW BUILD IMMEDIATE USING INDEX TABLESPACE LAPDATA REFRESH COMPLETE ON DEMAND WITH PRIMARY KEY AS SELECT * FROM UA_USER_MASTER@DB_LINK_LAPTEST_MFREP; SELECT * FROM UA_USER_MASTER@DB_LINK_LAPTEST_MFREP * ERROR at … Continue reading MVIEW creation on tables with “OBJECT TYPE”

Advertisement