Parameter to allow CTAS over DBLINK to maintain CHAR/VARCHAR2 column sizes
(Doc ID 285326.1)
Last updated on JULY 24, 2023
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 |