Home » RDBMS Server » Server Administration » Migration issue
Migration issue [message #210854] Fri, 22 December 2006 11:57 Go to next message
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

Re: Migration issue [message #210862 is a reply to message #210854] Fri, 22 December 2006 13:05 Go to previous messageGo to next message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
>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)
1) My math must be different than yours. I see only 2 times increase.
2) I SERIOUSLY doubt the "automatically" , because NOTHING in Oracle would automagically change field sizes.

EXACTLY how is the migration occuring?
Do both databases use the SAME characterset?
Re: Migration issue [message #211205 is a reply to message #210854] Wed, 27 December 2006 04:01 Go to previous message
jaydba
Messages: 86
Registered: September 2006
Location: UK
Member

It was typed by mistake. It increase three times means 60 (20*3)lenght-wise.
Previous Topic: Impact of parameter changes in server
Next Topic: export with wildcard characters and dependant objects
Goto Forum:
  


Current Time: Sat Dec 03 01:29:24 CST 2016

Total time taken to generate the page: 0.07344 seconds