Table naming issues while migrating I-series v5r4 to Oracle
hi sir,
will a migration possible between iseries v5r4 to oracle ??
if it is possible then will there be any issues regarding table naming i,e tables having names more than 10 charecters will get migrated ?? here in our scenario our source db has tables with names more than 10 charecters and the db is implicitly converting the name to a system table name with 10 charecters .. if we migrate that to oracle.. will take the original name or system table name..?? will this create any issue or will there be any other naming issues ??
Source DB : iSeries v5r4 Target DB : Oracle
pls let me know .. thanks..
Software/Hardware used:
will a migration possible between iseries v5r4 to oracle ??
if it is possible then will there be any issues regarding table naming i,e tables having names more than 10 charecters will get migrated ?? here in our scenario our source db has tables with names more than 10 charecters and the db is implicitly converting the name to a system table name with 10 charecters .. if we migrate that to oracle.. will take the original name or system table name..?? will this create any issue or will there be any other naming issues ??
Source DB : iSeries v5r4 Target DB : Oracle
pls let me know .. thanks..
Software/Hardware used:
ASKED:
June 21, 2012 12:17 PM
UPDATED:
June 26, 2012 2:11 PM
Answer Wiki:
I'm not sure how you wish to proceed in 'converting' a DB2 table to Oracle? Personally, I would be creating the tables in Oracle with whatever names I wish, then write some migration programs in some language (maybe Java) that can utilise xDBC to both Oracle and DB2 iSeries and just map all the data from old to new.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
