Error crating materialized view using database links.
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