Database DataWarehousing (MOSC)

MOSC Banner

How to perform Exchange Partition/SubPartition

This thread is for discussion and questions about Exchange Partition Option.

General Advice:

Below documents will explain the steps required to Exchange partition.

  • Exchange Partition - Examples (Doc ID 132989.1)
  • How To Exchange Table Subpartition With Data And Its All LOCAL Partition Indexes ? (Doc ID 1967782.1)
  • How to Apply Exchange Partition Method on Reference-partitioned Table (Doc ID 1365520.1)

Reference:

Master Note for Partitioning (Doc ID 1312352.1)

Example of Script to Maintain Range Partitioned Table (Doc ID 166652.1)

Exchange Partitions - Common Problems (Doc ID 198120.1)

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center