Database DataWarehousing (MOSC)

MOSC Banner

Error crating materialized view using database links.

edited Aug 30, 2010 12:52AM in Database DataWarehousing (MOSC) 2 commentsAnswered
Hi,

I get an error when I want to create materialized views on my local database. The local database is Oracle Database 10g Express Edition. And the master database is Oracle Database 10g Enterprise Edition Release 10.2.0.3.0.

I have create 2 database links on the local database:

CONNECT system/*****@xe;
CREATE PUBLIC DATABASE LINK gistest2 USING 'gistest2';

CONNECT mvadmin/*****@xe;
CREATE DATABASE LINK gistest2
CONNECT TO proxy_mviewadmin IDENTIFIED BY proxy_mviewadmin;

When I create this meterialized view on the local database:
    CREATE MATERIALIZED VIEW DRIVE3.ALDBDATATYPE 
    BUILD IMMEDIATE
    REFRESH FAST ON COMMIT
    AS SELECT DBDATATYPE, KOLONNENAVN FROM
    DRIVE3.ALDBDATATYPE@GISTEST2

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