Database DataWarehousing (MOSC)

MOSC Banner

How to move Partition/Subpartition to Different Tablespace

This thread is for discussion and questions about MOVE Partition/Subpartition to different Tablespace.

General Advice:

Below documents will explain the steps required to move a partitioned table to a different tablespace.

How to Move a Partitioned Table To A New Tablespace (Doc ID 1474267.1)

How To Move Partitioned Tables to Another Tablespace When They Contain LOBs (Doc ID 1388957.1)

How to Add a Partition/Subpartition & Move a Partition/Subpartition to Different Tablespace (Doc ID 973776.1)

From 12c, DML are allowed during Online Move Partition. ALTER TABLE MOVE PARTITION becomes non-blocking online DDL. Global indexes and local indexed are maintained during the move partition, so a manual index rebuild is no longer required. The online partitioning movement removes the read-only state for the actual MOVE PARTITION command.

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