Re: delete old partitions oracle 12c

Posted by Roshan on May 11, 2017; 9:30am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/delete-old-partitions-oracle-12c-tp2672p2678.html

I noticed when I omit INTERVAL='YES', the output does not display. Else, it would display

SELECT  PARTITION_NAME,

                  HIGH_VALUE

            FROM  USER_TAB_PARTITIONS

            WHERE TABLE_NAME = 'MOBILE_TAP';

MOBILE_TAP_2016_08 TO_DATE(' 2016-09-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')
MOBILE_TAP_2016_09 TO_DATE(' 2016-10-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')
MOBILE_TAP_2016_10 TO_DATE(' 2016-11-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')
MOBILE_TAP_2016_11 TO_DATE(' 2016-12-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')
MOBILE_TAP_2016_12 TO_DATE(' 2017-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')
MOBILE_TAP_2017_01 TO_DATE(' 2017-02-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')

Regards,
Roshan