Errors Creating Material Views
(Doc ID 2190573.1)
Last updated on FEBRUARY 05, 2024
Applies to:
Oracle Utilities Meter Data Management - Version 2.1.0.3 and laterInformation in this document applies to any platform.
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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |