Primary Note for MVIEW 'ORA-' error diagnosis. For Materialized View CREATE or REFRESH, DBMS_MVIEW
(Doc ID 1087507.1)
Last updated on NOVEMBER 07, 2023
Applies to:
Oracle Database Cloud Exadata Service - Version N/A and laterOracle Database Cloud Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database - Enterprise Edition - Version 10.1.0.5 to 12.2.0.1 [Release 10.1 to 12.2]
Information in this document applies to any platform.
Purpose
This article has been created to provide a path to existing My Oracle Support articles that have been written to cover the many possible 'ORA-' related issues that can arise from the creation, refresh and general maintenance of Materialized Views (also know as - Snapshots / MVIEW).
Please follow the links above or use the error message you would like a possible solution to as the search criteria (Ctrl-f) within this document.
The search will take you to the section that explains the error, and provides links to existing
documents (where they exist) in My Oracle Support. These documents have been written from previous
occurance of the error and show the Cause and Solution in each case.
Which ORA- error message should I use?
The error messages will appear as a single line or part of an error stack. It is a good idea to use the
correct error as some are just high level errors that are not too important initially.
Example 1.
ORA-12028: materialized view type is not supported by master site @%s
Example 2.
ORA-12012: error on auto execute of job 32
ORA-12008: error in materialized view refresh path -- These 2 lines are
ORA-01008: not all variables bound -- significant here
ORA-02063: preceding line from %s
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2251
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2457
ORA-06512: at "SYS.DBMS_IREFRESH", line 685
ORA-06512: at "SYS.DBMS_REFRESH", line 195
Scope
This is article is intended for DBA's, Users and Support Engineers who have received an ORA- type error when running, refreshing or creating Materialized Views (MVIEWs).
Details
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
Purpose |
Which ORA- error message should I use? |
Example 1. |
Example 2. |
Scope |
Details |
Error List with explanations and links to Oracle Support Articles |
ORA-00001: unique constraint (%s.%s) violated |
ORA-00912: input parameter too long |
ORA-00942: table or view does not exist |
ORA-01031: insufficient privileges |
ORA-01405: fetched column value is NULL |
ORA-02292: integrity constraint (string.string) violated - child record found |
ORA-02067: transaction or savepoint rollback required |
ORA-03113: "end-of-file on communication channel" |
ORA-04021: timeout occurred while waiting to lock object %s%s%s%s%s". |
ORA-04052: error occurred when looking up remote object |
ORA-04063: package body "SYS.DBMS_SNAP_INTERNAL" has errors |
ORA-04068: existing state of packages has been discarded |
ORA-06502: PL/SQL: numeric or value error |
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 9999, ( at "SYS.DBMS_SNAPSHOT" , at "SYS.DBMS_REFRESH") |
ORA-08103: object no longer exists |
ORA-10980: prevent sharing of parsed query during Materialized View query generation |
ORA-12004: "REFRESH FAST cannot be used for materialized view ..." |
ORA-12008: error in materialized view refresh path/ORA-01008: not all variables bound |
ORA-12015: cannot create a fast refresh materialized view from a complex query |
ORA-12020: materialized view %s is not registered |
ORA-12028 materialized view type is not supported by master site string |
ORA-12031: cannot use primary key columns from materialized view log on |
ORA-12032: cannot use rowid column from materialized view log on %s . %s |
ORA-12033: cannot use filter columns from materialized view log on "string"."string" |
ORA-12034: materialized view log on "SCOTT"."%s" younger than last refresh |
ORA-12052 cannot fast refresh materialized view ( %s . %s ) |
ORA-12054: cannot set the ON COMMIT refresh attribute for the materialized view |
ORA-12096: error in materialized view log on %s . %s |
ORA-12541: TNS:no listener |
ORA-12899 value too large for column %s (actual: %s, maximum: %s) |
ORA-16000: database open for read-only access |
ORA-21700: object does not exist or is marked for delete (with ORA-12018) |
ORA-22992: cannot use LOB locators selected from remote tables |
ORA-23313: object group "PUBLIC"."MY_TEST_GROUP" is not mastered at %s.%s |
ORA-23415: materialized view log for <master table > does not record the primary key |
ORA-30361 unrecognized string type |
ORA-30372: fine grain access policy conflicts with materialized view" |
ORA-32401 materialized view log on %s . %s does not have new values |
Additional Resource -Community Discussions |
References |