Create Materialized view takes long time and session hang (pending ).
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?