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!

Is it possible to exchange multiple partitions?

Manoj0408May 29 2015 — edited Jun 1 2015

Is it possible to exchange multiple partitions? I have an Informatica mapping where I am loading a temp table. This temp table is exact replica of the original table with constraints and indexes.(original table is partitioned by range). The data in temp table is based on date, and there will be new partition for every date resulting into multiple partitions. So how can I exchange data from temp table with that of original table for the multiple partitions. Please correct me if I am wrong and let me know if there is any other approach to accomplish this.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 29 2015
Added on May 29 2015
3 comments
2,738 views