Errors Creating Material Views (Doc ID 2190573.1)

Last updated on FEBRUARY 05, 2024

Applies to:

Symptoms

An error occurs when creating Materialized Views, when running Materialized_View_Creation.sql

This script is located in Post-Upgrade folder within the MDM Database Portion and


ERROR
-----------------------
There are numerous errors in output file
PL/SQL procedure successfully completed.

WHERE BUS_OBJ_CD = 'D2-MeasuredQuantityMsrmt'
  *
ERROR at line 21:
ORA-00955: name is already used by an existing object


begin
*
ERROR at line 1:
ORA-23401: materialized view "CISADM"."D2_MEASR_QTY_AGR_MV" does not exist
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2821
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 3058
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 3017
ORA-06512: at line 2


ANALYZE TABLE D2_MEASR_QTY_AGR_MV COMPUTE STATISTICS
  *
ERROR at line 1:
ORA-01702: a view is not appropriate here

  *
ERROR at line 21:
ORA-00955: name is already used by an existing object


begin
*
ERROR at line 1:
ORA-23401: materialized view "CISADM"."D2_QUALITY_CNT_AGR_MV" does not exist
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2821
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 3058
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 3017
ORA-06512: at line 2


ANALYZE TABLE D2_QUALITY_CNT_AGR_MV COMPUTE STATISTICS
  *
ERROR at line 1:
ORA-01702: a view is not appropriate here




PL/SQL procedure successfully completed.

WHERE BUS_OBJ_CD = 'D2-TimelinessCountMsrmt'
  *
ERROR at line 21:
ORA-00955: name is already used by an existing object


begin
*
ERROR at line 1:
ORA-23401: materialized view "CISADM"."D2_TIMELINES_CNT_AGR_MV" does not exist
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2821
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 3058
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 3017
ORA-06512: at line 2


ANALYZE TABLE D2_TIMELINES_CNT_AGR_MV COMPUTE STATISTICS
  *
ERROR at line 1:
ORA-01702: a view is not appropriate here



PL/SQL procedure successfully completed.

WHERE BUS_OBJ_CD = 'D2-TimelinessQuantityMsrmt'
  *
ERROR at line 21:
ORA-00955: name is already used by an existing object


begin
*
ERROR at line 1:
ORA-23401: materialized view "CISADM"."D2_TIMELINES_QTY_AGR_MV" does not exist
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2821
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 3058
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 3017
ORA-06512: at line 2


ANALYZE TABLE D2_TIMELINES_QTY_AGR_MV COMPUTE STATISTICS
  *
ERROR at line 1:
ORA-01702: a view is not appropriate here





STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run Materialized_View_Creation.sql


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot create Materialized View / complete installation for this environment.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.