Skip to Main Content

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!

Please help me in getting a automated script to add and drop partitions(range) in oracle database 10

877460Jul 30 2014 — edited Aug 6 2014

Hi experts/gurus,

Please help me in getting a automated script to add and drop partitions(range) in oracle database 10g standalone database.

clauses are

Create partitions per week, 2 weeks ahead. Delete partitions after 3 weeks.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 3 2014
Added on Jul 30 2014
22 comments
5,895 views