Database DataWarehousing (MOSC)

MOSC Banner

Materialized view creation hangs per upgrade to 10G

edited Apr 3, 2017 5:05PM in Database DataWarehousing (MOSC) 23 commentsAnswered

Trying to re-create 'old materialized views' after the upgrade to 10g and some of them just hangs but ... select (that is used to create the materialized view) itself runs fine within 1 min in database... what is a problem ? Smth special about Create Materialzed view... or options I am using or database parameters? Here is my script - it is hang on:

WHENEVER SQLERROR EXIT FAILURE ROLLBACK

CREATE MATERIALIZED VIEW owner.viewname

TABLESPACE MI_TABLESPACE

PCTUSED    40

PCTFREE    10

INITRANS   2

MAXTRANS   255

STORAGE    (

            INITIAL          64K

            MINEXTENTS       1

            MAXEXTENTS       UNLIMITED

            PCTINCREASE      0

            FREELISTS        1

            FREELIST GROUPS  1

            BUFFER_POOL      DEFAULT

           )

NOCACHE

LOGGING

BUILD IMMEDIATE

REFRESH COMPLETE ON DEMAND

WITH PRIMARY KEY

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