Skip to Main Content
Forums

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jun 3 2008
Added on Apr 28 2008
#database-and-application-migrations
4 comments
8,731 views