Skip to Main Content
Forums

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 create and drop partitions automatically?

709798Aug 5 2009 — edited Aug 14 2009
How to create and drop partitions automatically?
The environment is Oracle 10g(10.2.0.3) on the RHEL4.0 system.
I want to partition the MESSAGE table by date (NUMTODSINTERVAL(1,'DAY') ). One partition per day. Because the table is huge, only 2 partitions (today and yesterday's data) are necessary to be kept online. All the partitions that earlier than the previous day will be backed up and then dropped. I want to make the partition creating and dropping jobs run automatically. How to do it?

Thank you
This post has been answered by Billy Verreynne on Aug 7 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 11 2009
Added on Aug 5 2009
#general-database-discussions
9 comments
4,456 views