This content has been marked as final. Show 12 replies
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