Database DataWarehousing (MOSC)

MOSC Banner

split partition in a range partition table

edited Jul 17, 2018 5:12AM in Database DataWarehousing (MOSC) 2 commentsAnswered

we have a range partitioned table which is partitioned by week and it has partitions by week (attached DDL for table, index) & has a maxvalue partition. we need to add partitions for the rest of the year  and currently it only has partitions till July. Since it has maxvalue we need to  split partitions as below -

ALTER TABLE rms13.week_data SPLIT PARTITION WEEK_DATA_MAX at (TO_DATE('2018-08-05 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) INTO (PARTITION WEEK_DATA_606, PARTITION MAXVALUE);

could you please let me know whether i need to rebuild the index (local) , this is the only index on the table  and it is partitioned local index

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