Column size double or triple when using (Materialized) Views / CTAS in an AL32UTF8 db and the dblink points to a non-AL32UTF8 db (or inverse).
(Doc ID 1592514.1)
Last updated on AUGUST 04, 2018
Oracle Database - Enterprise Edition - Version 184.108.40.206 and later Oracle Database - Standard Edition - Version 220.127.116.11 and later Information in this document applies to any platform.
Document why when using (Materialized) Views or doing CTAS (Create Table As Select ) of a table trough a database link in an AL32UTF8 db and the dblink points to a non-AL32UTF8 db you might see that (some) columns change in size.
DBA's or application architects
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!