Materialized View Created Between Different Characterset Database Using Substr Function May Have Incorrect Character Column Length
(Doc ID 2176871.1)
Last updated on FEBRUARY 28, 2019
Applies to:Oracle Database - Enterprise Edition - Version 188.8.131.52 to 184.108.40.206 [Release 12.1]
Information in this document applies to any platform.
Creating materialized view using substr function and between different multibyte characterset database, created materialized view can have smaller column length for character(CHAR,VARCHAR2) datatype than expected.
For example, consider db1 is JA16SJIS, db2 is AL32UTF8 characterset case, we will see following result
Due to this problem, create materialized view can fail with ORA-1406 because materialized view column length is short to put fetched data, and ORA-1723: zero-length columns are not allowed might be returned
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