Once a week, we run a script that replicates data from DB2 to Oracle. We encounter a problem with the field length created in Oracle. For example, a text field has a length of six characters in DB2, but in Oracle the field becomes 18. It is important that the field length is not increased when importing into Oracle. Any advice?
I'm not sure why six characters in DB2 requires 18 characters in Oracle. You might want to verify your script to ensure no other character conversion is taking place. Without seeing the script, I cannot be sure how the replication is being handled. Please feel free to email me at email@example.com if you want to share your script.
Dig Deeper on Oracle database backup and recovery
Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs.
One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command.
Managing parent table-child table relations in Oracle SQL environments is key to efficient programming.