ORA-12899 REFRESH MVIEW AFTER CHARACTERSET CHANGE

(Doc ID 1356970.1)

Last updated on OCTOBER 25, 2011

Applies to:

Oracle Server - Enterprise Edition - Version: 11.2.0.2 and later   [Release: 11.2 and later ]
Oracle Server - Enterprise Edition - Version: 11.2.0.2 and later    [Release: 11.2 and later]
Information in this document applies to any platform.

Symptoms

A manual refresh of a MView in target database with characterset of UTF8 customer receives an ora-12899 error.  When the same MView is manually refreshed in the source database with characterset of WE8ISO8859P1, no error is received.

Changes

Conversion of the database characterset from WE8ISO8859P1 on the source site to UTF8 on the master site was completed using export/import.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms