My Oracle Support Banner

Parameter to allow CTAS over DBLINK to maintain CHAR/VARCHAR2 column sizes (Doc ID 285326.1)

Last updated on MARCH 05, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 9.2.0.1 to 10.2.0.1 [Release 9.2 to 10.2]
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
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.
Information in this document applies to any platform.

Goal

CREATE TABLE AS SELECT (CTAS) over a dblink between databases with different
multibyte character sets can result in a table definition which has column lengths
either 3 times the size of the original table definition.
This is correct behaviour but there are cases where the new (correct) behaviour
is undesirable.

Solution

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
Goal
Solution
References


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