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!

Possible to swap multiple partitions into a table?

user5716448Sep 28 2012 — edited Oct 1 2012

Hi,

We are using partition exchnage to swap individual partitions into table which then backed up.

This being done one partition at a time.

Is it possible to swap several partitions of a tabel in one go.

using Oracle 11.2.0.3

partioned by date, one partition of reach day.

Is it possible say to move the last 7 days partitions into the other table for backup using partition exchange?

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 29 2012

Added on Sep 28 2012

#general-database-discussions

9 comments

1,444 views