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