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!

Migrating DB2 to Oracle

972512Nov 5 2012 — edited Nov 9 2012

Hi,
I have a requirement to migrate DB2 v9.5.0.5 to Oracle Database 11g Enterprise Edition 11.2.0.2.0.

I noticed that the migration tool supported by Oracle SQL Developer helps in migrating a Database from db2. In my case, the database in DB2 has multiple schemas and I want to migrate only one schema to Oracle. Is there some way to restrict the migration to only one schema? The quick migrate option is working only at a table level but not on a schema level.

Thanks a lot in advance and Best Regards
Moorthy

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 7 2012

Added on Nov 5 2012

#database-and-application-migrations

4 comments

2,852 views