PL/SQL (MOSC)

MOSC Banner

Materialized Views

edited Apr 15, 2010 9:28AM in PL/SQL (MOSC) 4 commentsAnswered
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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center