Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Delete the partitioned older than 13 months

User_ZB1C4Jul 26 2017 — edited Jul 27 2017

Hello,

I have a partitioned table (Partitioned by list), with high_value as mentioned below format - ('YYYYMM')

.......

'201612'

'201611'

'201610'

'201609'

'201608'

'201607'

'201606'

'201605'

'201604'

'201603'

'201602'

'201601'

'201512'

'201511'

.........

I need to drop the partitions which are older than 13 months, this I will be repeating every month. Could you please help me with the script?

This post has been answered by Sevdimali Isayev on Jul 27 2017

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 24 2017

Added on Jul 26 2017

#general-database-discussions

14 comments

7,500 views