I have a table which is partitioned on ts_date ( Interval partition) now requirement is to create sub partition on run_id column which is being populated from sequence.

For one ts_date there may be 10 run_ids.

Problem is Oracles doesn’t support interval sub partitions.

Please advice how to achieve this scenario.