Parameter to allow CTAS over DBLINK to maintain CHAR/VARCHAR2 column sizes

(Doc ID 285326.1)

Last updated on FEBRUARY 06, 2017

Applies to:

Oracle Server - Enterprise Edition - Version: 9.2.0.1 to 10.2.0.1
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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms