My Oracle Support Banner

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 to [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

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