ORA-12899 REFRESH MVIEW AFTER CHARACTERSET CHANGE (Doc ID 1356970.1)
Last updated on OCTOBER 25, 2011
Oracle Server - Enterprise Edition - Version: 126.96.36.199 and later [Release: 11.2 and later ] Oracle Server - Enterprise Edition - Version: 188.8.131.52 and later [Release: 11.2 and later] Information in this document applies to any platform.
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.
Conversion of the database characterset from WE8ISO8859P1 on the source site to UTF8 on the master site was completed using export/import.
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