hi

ı did table export from baan4 (oracle 7 ) to other baan4 (oracle 10g) using baan tool.

but ı saw a strange situation . there are two fields in orginal table as 255 char and 45 char length. after import ı saw only one field with 300 char length.so import process joined two fields eachother.

have you got any ideas ?

I have a few questions:
Did you use the tools ttaad4226m000 and ttaad4227m000 to export/import?
What did you use as field separator?
Which table has the error?
Do the baan versions (service pack, porting set) differ?

Greets
Litrax

yes ı used the tools ttaad4226m000 and ttaad4227m000 to export/import.
baan version 4
source oracle version 7
destination oracle version 10g
ı didnt use field separator
table name is ttdsmi87
porting sets are different

thanks

It's a know issue, before it wasn't possible to have fields longer than 255 chars. Later version do support longer fields.
To be honest I am not sure if it was an oracle 'problem' or not.

Anyway it doesn't matter for your application unless you build something around the table yourself.
I beliefe there is even an resource variable for this (oracle7:1) which can be used with the new driver to simulate the old behaviour. Not sure if that's still supported in the latest portingsets.

Regards,

have you used field separate for export/import ?
thanks