Materialized Views
I Have Windows 2003 environment and Oracle 9i database.
Lately unpgraded a dev db to 11G and now testing materialized views.
This is my script:
connect cc/cc@cnx;
drop public database link HOX;
create public database link "HOX" connect to "cc" identified by "cc" using 'HOX';
drop materialized view CaseParty;
Create materialized view Casing for update as select * from Casing@HOX.cc.org.za;
It produce error ORA-00942 Table or view does not exist.
This "select * from Casing@HOX.cc.org.za;" produce a result set
and this "Create materialized view Casing for update as select * from dba_indexes@HOX.cc.org.za