Create Materialized view takes long time and session hang (pending ).
Problem Description: I have two sites master site and materialized View site , I created database link , it worked succesfuly and i tried to create materialized view in MV site but the session hang and takes long time and the Materialized view does not created the session pending even one day long time .
Note : I give all grants to create MV .
* Oracle release for master and mview instances
master site (11.1.0.6) Mview site (11.1.0.7)
* The mview creation script?
CREATE MATERIALIZED VIEW ACCESS_GROUPS_CD REFRESH FAST WITH PRIMARY KEY FOR UPDATE
AS SELECT * FROM LOL.ACCESS_GROUPS_CD@HQ ;
* Does the CREATE TABLE xxxx AS SELECT (same select as used in mview) work fine? Does it hang too?