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!

drop interval partitions

User_MIMMVMay 27 2020 — edited Jul 10 2020

Hi,

I have 4 transactions tables that I am planning to have interval partitioned on date column.

The retention for the table is 1 day. I would like to schedule a job at around 2AM every night to drop previous day's partition.

As the partition names are system generated I am looking for a simple procedure to pick up the correct partition name and drop it for the 4 tables.

Can some one please help me with this?

Oracle: 12.2 0.1.0

This post has been answered by Jonathan Lewis on May 27 2020

Jump to Answer

Added on May 27 2020

#general-database-discussions

11 comments

2,354 views