Since HIGH_VALUE in DBA_TAB_PARTITION view is LONG type, so it is difficult to get the system generated interval partition name straight away. The following will lead you how to get it easily.
SQL> desc dba_tab_partitions
Name Null? Type
----------------- -------- ------------
TABLE_OWNER VARCHAR2(30)
TABLE_NAME VARCHAR2(30)
COMPOSITE VARCHAR2(3)
PARTITION_NAME VARCHAR2(30)
SUBPARTITION_COUNT NUMBER
HIGH_VALUE LONG
...
.
Subscribe to get access
Read more of this content when you subscribe today.
Make DBA Life Easy 