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!

importing a partitioned table using datapump from enterprise edition (12c) to standard edition (12c)

ilputtoFeb 18 2018 — edited Feb 20 2018

Hello Everyone,

I would like to know if it is possible to import a full database datapump dump with many partitioned tables within , into a Standard edition2 database.

As you know standard edition 2 doesn't use the partition option, and I would like to know if I can use the PARTITION_OPTIONS=MERGEĀ  impdp opion to accomplish this task.

Thank you in advance for any reply

Regards

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 20 2018
Added on Feb 18 2018
11 comments
2,163 views