Database Administration (MOSC)

MOSC Banner

Does Oracle support hyrbid range/list partition mixed with interval partitions?

We have a couple tables that are partitioned by range and subpartitioned by list (which correspond roughly to year and month, respectively, but not exactly). I am reading some documentation about interval partitions, but I have not yet been able to determine if Oracle supports a mix of range/list partitions alongside intervals partitions, or does it have to be all one way or the other? If the latter, what tools does Oracle provide to convert non-interval partitions to interval partitions? And can we still use ranges and lists both with interval partitions in the way we have been in the

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