Database Administration (MOSC)

MOSC Banner

Optimal Technique for Table Partition (Maxval) Removal

In our one of our Database we have several partitioned tables who have a final partition with MAXVALUE; hence all current data entries are flowing in. The tables are date range partitioned tables. We wish to remove the maxvalue partition, implement Oralce Automatic Managed Partitioning, while preserving the data from the MAXVALUE partition (implemented a few years ago).


Traditionally, splitting the MAXVALUE partition into defined date partitionsdropping the MAXVALUE partition setting table with partition interval (here monthly)


is used. However the challenge is the Maintenance Window timing (a few hours). The above can be split into multiple maintenance, but with several years of data this will take some time.

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