My Oracle Support Banner

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 later
Oracle 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

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