Skip to Main Content
Forums

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Exchange partition from partitioned table to partitioned table

MarwimFeb 21 2019 — edited Feb 26 2019

Hello,

I have some list partitioned tables in schema A and want to move some data to partitioned tables in schema B - it is not a one time job.

While partition exchange sounds good IMHO it can't exchange partitions between partitioned tables.

  1. I might move data from table XY by exchanging partitions from A.XY to a non partitioned B.STAGE_XY and then to B.XY but then I have to do two exchanges and I have to maintain an additional table or
  2. I can create the new partition on B.XY, create an INSERT and execute as dynamic SQL and drop the partition from A.XY.

Any arguments pro/contra or maybe you know a different solution?

Marcus

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

With the Partitioning option
This post has been answered by Jonathan Lewis on Feb 25 2019
Jump to Answer
Comments
Post Details
Added on Feb 21 2019
#general-database-discussions
16 comments
2,259 views