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!

Migrate database from 10g to 12c using expdp/impdp

2998758Apr 25 2016 — edited Apr 27 2016

I'm currently running Oracle 10.2.0.4 on Redhat 5.3. I need to migrate it to Oracle 12c SE2 on Redhat 6.2 on new hardware. I plan to use full expdp / impdp to perform the migration

My questions are

1. My current database is Oracle 10g Enterprise Edition, the new database will be on 12c SE2. Does full expdp / impdp works in this scenario?

2. As far as I know, full impdp does not import System tablespaces, should I use full expdp / impdp or just expdp / impdp the data tablespaces only? Which one is better over then other?

3. Where do I find a complete checklist of this kind of migration process?

Regards,

Amanda

Locked Post

New comments cannot be posted to this locked post.

Locked on May 25 2016

Added on Apr 25 2016

#general-database-discussions

10 comments

4,257 views