My Oracle Support Banner

Materialized View Refresh Failing with errors ORA-12008 ORA-31600 ORA-30372 (Doc ID 2738707.1)

Last updated on FEBRUARY 01, 2021

Applies to:

Oracle Database - Enterprise Edition - Version 19.3.0.0.0 and later
Information in this document applies to any platform.

Symptoms

On : 19.3.0.0.0 version, Materialised Views

Materialized View Refresh Failing below errors.

The creation of the materialized view works fine, but the refresh fails.

SQL> exec BEGIN DBMS_MVIEW.REFRESH('<owner>.xxx', method => 'CF',atomic_refresh => FALSE,out_of_place => TRUE); END;
BEGIN BEGIN DBMS_MVIEW.REFRESH('VALUATION.WS_PROPERTY_SEARCH_VW', method => 'CF',atomic_refresh => FALSE,out_of_place => TRUE); END; END;

*
ERROR at line 1:
ORA-12008: error in materialized view or zonemap refresh path
ORA-06512: at "SYS.DBMS_SNAPSHOT_KKXRCA", line 3012
ORA-06512: at "SYS.DBMS_SNAPSHOT_KKXRCA", line 2424
ORA-31600: invalid input value COMPATIBLE for parameter VERSION in function
OPEN
ORA-06512: at "SYS.DBMS_SNAP_INTERNAL", line 1487
ORA-06512: at "SYS.DBMS_METADATA", line 6516
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.DBMS_METADATA", line 6422
ORA-06512: at "SYS.DBMS_METADATA", line 6762
ORA-06512: at "SYS.DBMS_SNAP_INTERNAL", line 1427
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_SNAPSHOT_KKXRCA", line 88
ORA-06512: at "SYS.DBMS_SNAPSHOT_KKXRCA", line 253
ORA-06512: at "SYS.DBMS_SNAPSHOT_KKXRCA", line 2405
ORA-06512: at "SYS.DBMS_SNAPSHOT_KKXRCA", line 2968
ORA-06512: at "SYS.DBMS_SNAPSHOT_KKXRCA", line 3255
ORA-06512: at "SYS.DBMS_SNAPSHOT_KKXRCA", line 3287
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 16
ORA-06512: at line 1
 

ERROR
-----------------------
ORA-12008 ORA-31600
 

Changes

Refresh works fine with "USING TRUSTED CONSTRAINTS", but fails when MView created with "USING ENFORCED CONSTRAINTS" .

ORA-30372 error found on internal objects only.

No policy found, No Fine grained access policy found on objects or no VPD access found. 

And With "out_of_place" => FALSE works fine but TRUE fails.

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


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