Q
Problem solve Get help with specific problems with your technologies, process and projects.

Field length increasing during replication from DB2 to Oracle

Once a week, we run a script that replicates data from DB2 to Oracle. The field length is increasing in Oracle.

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 dba@peasland.com if you want to share your script.

Dig Deeper on Oracle database backup and recovery

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close