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 APRIL 25, 2023
Applies to:
Oracle Database - Enterprise Edition - Version 9.0.1.0 and laterOracle Database - Standard Edition - Version 9.0.1.0 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.
Purpose
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.
Scope
DBA's or application architects
Details
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
Purpose |
Scope |
Details |
From a 16bit (xx16xxxx like ZHT16MSWIN950), 8 bit (xx8xxxx like WE8ISO8859P1 or AR8MSWIN1256) or 7 bit (US7ASCII) source to AL32UTF8 (CTAS target/(Materialized) View side) database: |
From an AL32UTF8 source to a 16 bit (xx16xxxx like ZHT16MSWIN950) , 8 bit (xx8xxxx like WE8ISO8859P1 or AR8MSWIN1256) or 7 bit (US7ASCII) (CTAS target/(Materialized) View side) database: |
From AL32UTF8 to UTF8 or inverse: |
References |