R12.1.1 ; Error creating "APPS"."BIV_B_AGE_H_SUM_MV" materialised view during 12.1.1 upgrade.
HI,
Error creating "APPS"."BIV_B_AGE_H_SUM_MV" materialised view during 12.1.1 upgrade.
log file is showing :
================================================================================
Applying XDF file : /u01/app/oracle/apps/apps_st/appl/biv/12.0.0/patch/115/xdf/biv_b_age_h_sum_mv.xdf
================================================================================
Materialized View Name is BIV_B_AGE_H_SUM_MV
Materialized View does not exist in the target database
Executing create Statement
Create Statement is
CREATE MATERIALIZED VIEW "APPS"."BIV_B_AGE_H_SUM_MV"
ORGANIZATION HEAP PCTFREE 10 PCTUSED 40 INITRANS 10 MAXTRANS 255 LOGGING
STORAGE(INITIAL 4096 NEXT 131072 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 4 FREELIST GROUPS 4 BUFFER_POOL DEFAULT)
TABLESPACE "APPS_TS_SUMMARY"
BUILD DEFERRED
USING INDEX PCTFREE 10 INITRANS 11 MAXTRANS 255
Error creating "APPS"."BIV_B_AGE_H_SUM_MV" materialised view during 12.1.1 upgrade.
log file is showing :
================================================================================
Applying XDF file : /u01/app/oracle/apps/apps_st/appl/biv/12.0.0/patch/115/xdf/biv_b_age_h_sum_mv.xdf
================================================================================
Materialized View Name is BIV_B_AGE_H_SUM_MV
Materialized View does not exist in the target database
Executing create Statement
Create Statement is
CREATE MATERIALIZED VIEW "APPS"."BIV_B_AGE_H_SUM_MV"
ORGANIZATION HEAP PCTFREE 10 PCTUSED 40 INITRANS 10 MAXTRANS 255 LOGGING
STORAGE(INITIAL 4096 NEXT 131072 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 4 FREELIST GROUPS 4 BUFFER_POOL DEFAULT)
TABLESPACE "APPS_TS_SUMMARY"
BUILD DEFERRED
USING INDEX PCTFREE 10 INITRANS 11 MAXTRANS 255
Tagged:
0