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

Report message to a moderator

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: 26766
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?

Report message to a moderator

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.

Report message to a moderator

Previous Topic: Impact of parameter changes in server
Next Topic: export with wildcard characters and dependant objects
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 05:36:44 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.