I am trying to create table in Oracle 11g as select from a table in SQL Server 2012 via database link.
The table in SQL Server contains column: hslakkis varchar(3)
In Oracle it created the table with the same column but different size:
hslakkis varchar2(9)
This behavior causes me a lot of problems with the columns size in Oracle.
How can I prevent Oracle from increasing the column size?
Best Answer
This is a feature that's controllable by a parameter. From the documentation:
Basically, Oracle is assuming that all of the data in the source table may take up 3 bytes per character, due to characterset conversion.