My Oracle Support Banner

ORA-12899 error during distributed Materialized View refresh (Doc ID 2761173.1)

Last updated on FEBRUARY 05, 2022

Applies to:

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

Symptoms

ORA-12008: error in materialized view or zonemap refresh path
ORA-06512: at "SYS.DBMS_SNAPSHOT_KKXRCA", line 3020
ORA-06512: at "SYS.DBMS_SNAPSHOT_KKXRCA", line 2432
ORA-12899: value too large for column "<OWNER>"."<MVIEW NAME>"."<COLUMN NAME>" (actual: 3, maximum: 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 2413
ORA-06512: at "SYS.DBMS_SNAPSHOT_KKXRCA", line 2976
ORA-06512: at "SYS.DBMS_SNAPSHOT_KKXRCA", line 3263
ORA-06512: at "SYS.DBMS_SNAPSHOT_KKXRCA", line 3322
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 44
ORA-06512: at "SYS.DBMS_IREFRESH", line 1177
ORA-06512: at "SYS.DBMS_REFRESH", line 263
ORA-06512: at line 1

Snapshot Database upgraded from 12c to 19c - Oracle Database 19c Enterprise Edition Release 19.0.0.0.0

Primary Database version is 11g - 11.2.0.3.0

 

This error only appearing after upgrading snapshot site from 12c to 19c

Changes

Snapshot database upgraded from 12c to 19c UTF8 characterset 

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


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