Database DataWarehousing (MOSC)

MOSC Banner

Re-partitioning a table using different field

edited Apr 25, 2017 9:05AM in Database DataWarehousing (MOSC) 2 commentsAnswered

Hi,

We have a table TRAN_DATA_HISTORY with range partition on 'tran_date' we want to re-partition this table using a different field 'post_date'. Is there an easier way to do it without converting the partitioned table to a non-partitioned table, and then doing the partition on post date.

I tried to use exchange partition but it only works on converting a non-partitioned table to partitioned.

Also, if there is no other way than partitioned -> non-partitioned -> partitioned, how can I un-partition a partitioned table?

Thanks.

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