Materialized Views

Hi,

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