Materialized view creation hangs per upgrade to 10G
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