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!

shell/PL SQL partition script

498001Jul 31 2009 — edited Jul 31 2009

Hi

Does anyone have a shell/PL SQL script that I can run once a month that will add next months partition and drop the oldest partition of a partitioned table that is partitioned by month?

Thanks in advance.

Kumar.

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 28 2009

Added on Jul 31 2009

#general-database-discussions

4 comments

1,319 views