Migration issue [message #210854] |
Fri, 22 December 2006 11:57 |
jaydba
Messages: 86 Registered: September 2006 Location: UK
|
Member |
|
|
when we migrate the database from Oracle 8.1.7 to 10.2, the width of varchar2 data type increases three times from oracle old version to new version in the table structure. We tested through many using differnet mechanisms for migrating,database link, replication for two databases. But, It increase three times width for this data type.
eg. Oracle 8.1.7 - Table Emp Empnm varchar(20)
becomes automatically in Oracle 10g for Emp table - empnm varchar2(40)
Your comments would be appreciated.
thanks in advance
|
|
|
|
|