Install, Upgrade, Clone, Patch - EBS (MOSC)

MOSC Banner

R12.1.1 ; Error creating "APPS"."BIV_B_AGE_H_SUM_MV" materialised view during 12.1.1 upgrade.

edited Dec 13, 2012 12:11AM in Install, Upgrade, Clone, Patch - EBS (MOSC) 8 commentsAnswered ✓
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
Tagged:

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