Skip to Main Content

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!

Datapump export from 12c to 10g

3801234Sep 27 2018 — edited Sep 28 2018

Hi everyone,

This is my first post here and am currently learning the ropes of using datapump to migrate data. A problem came up was when I tried exporting from 12c then importing on to 10g. At first I thought the versioning parameter would solve the issue but after a bit of troubleshooting, I found out that if I set the versioning parameter to 10.2 upon export, the tables fail to create and I'm faced with the error: ORA-39166 Object ..... was not found or could not be exported or imported. How then can I push through with the export having all the object I need in them?

Thank you!

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 26 2018
Added on Sep 27 2018
3 comments
3,225 views