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 laterInformation 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 |