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!

MySQL to Oracle - Migrate Data in SQL Developer

636487Apr 28 2008 — edited May 6 2008

I tried to migrate MySQL 4.2 to Oracle 10g using the Quick Migrate method in Oracle SQL Developer. Everything went fine except for a few tables which have data loading errors, two tables simply got no data migrated at all every time I tried. Two other tables got partial data migrated. My questions are:

1. How can I migrate individual table data?

2. What could be the possible causes of no data migrated on the two tables? One has 176,074 rows, the other 1,792,318 rows.

3. How can I see a detailed list of errors occured during data migratation?

4. Is there any way to speed up the data migration? I postponed the index creation until after the data load.

Any help would be much appreciated. Thanks!

Tracy Liang
xl2191@att.com

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 3 2008

Added on Apr 28 2008

#database-and-application-migrations

4 comments

8,860 views