Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to migrate the data in AS/400 to Oracle

User8025805-OracleOct 2 2010 — edited Oct 6 2010

I have a customer, they plan to migrate their data from AS/400 DB2 V5R3,V6R1 to Oracle 11g. Since the source system is in production, they can only halt for 48 hours,
which way is the fastest?

ORACLE workbench can only support to IBM DB2/400 V4R3 and V4R5, must we export the data from AS400 to ASCII then sql load to Oracle, the user data size is about 3T?
even get the initial data, how to capture the increased data? Oracle GoldenGate 11g can't access AS400 as source.

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 3 2010

Added on Oct 2 2010

#database-and-application-migrations

2 comments

3,991 views