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!

How to select oldest partition and drop

31005Feb 24 2006 — edited Feb 24 2006

I need to drop the oldest partition of a table on the 1st of every month. I would like to automate this. How do I find the oldest partition? Then drop it?

Thanks,

jason

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 24 2006

Added on Feb 24 2006

#general-database-discussions

4 comments

386 views