I've two dbs. The master database is version 10.2.0.5 and the database with the m-view is version 184.108.40.206. Now I want to refresh the m-view with the fastoption, but I receive allways the Error-Code: ORA-12028 when I want to create the m-view with the fast refresh option.
Thanks for the support.
How can I move my post? Must I create a new one?
CREATE MATERIALIZED VIEW TEST.HUGO(COLUM1, COLUM2)
REFRESH FAST ON DEMAND
WITH PRIMARY KEY
SELECT * FROM "TEST"."TABLE"@DATABASELINK "TABLE";
You have quite a long domain name. Check if DB_DOMAIN has been set.
If these are test environments, I suggest setting a more meaningful DB_DOMAIN name --- however this will impact Database Links.
Also, I suggest that you look at these Articles on support.oracle.com :
How to deal with ORA-12028 reported when creating a Fast Refreshable Remote Mview [ID 1059547.1]
Create Materialized View Fails with ORA-12028 [ID 1321715.1] Bug 6074902 - ORA-12028 for Materialized View if DB link name has special characters [ID 6074902.8]
Log an SR with Oracle support. They'll help you trace the CREATE MATERIALIZED VIEW operation.
Hemant K Chitale
i have sam problem
my snapshot log create on oracle 10.2.0.1.0
CREATE SNAPSHOT LOG ON TBL_PERSON WITH PRIMARY KEY;
and snapshot create on oracle 220.127.116.11.0
CREATE SNAPSHOT TBL_PERSON BUILD DEFERRED REFRESH FAST WITH PRIMARY KEY AS SELECT * FROM TBL_PERSON@DBLINK;
I get error ORA-12028: materialized view type is not supported by master site@"DBLINK.LOCALDOMAIN"
please help me