'How to create sub partition in already interval partitioned table in oracle

I have a table which is interval partitioned on date column. I want to sub partition on these already created partition into list partitioning.

How can I do this in Oracle?

Suppose there is a table in which there exists a date column and a region column along with the other columns.

Table is already interval partitioned with this date column.

Now I want these interval partition to sub partition on the basis on the region column.

How will it be possible?

oracle oracle19c

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Solution	Source