Database DataWarehousing (MOSC)

MOSC Banner

Create Materialized view takes long time and session hang (pending ).

edited Aug 2, 2010 10:49PM in Database DataWarehousing (MOSC) 13 commentsAnswered
  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?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center