CODEWITHSUNDEEP
oracle-database
Dinu Nicolae
Dinu Nicolae

Reputation: 1281

Is it possible to automatically create a new partition in a list partitioned table?

The code below would create a new partition if I would insert a date that does not exist in my table. Is it possible to do the same thing in a list partitioned table, where the partition is based on a VARCHAR2 column?

 ALTER TABLE MY_TABLE MODIFY
    PARTITION BY RANGE(DATE) INTERVAL(NUMTODSINTERVAL(1,'day'))
( partition MY_PARTITION values less than (to_date('2019-06-01', 'yyyy-mm-dd')));

Upvotes: 2

Views: 189

Answers (1)

Maxim Borunov
Maxim Borunov

Reputation: 911

Yes, it is possible starting from the Oracle 12.2. See the details here.

Upvotes: 2

Related Questions