Skip to Main Content
Forums

SQL & PL/SQL

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 on Timestamp partition key monthly

rock_001Aug 11 2016 — edited Aug 14 2016

Hi,

I have a situation here where I need to drop the interval partitions on a monthly basis, but the partition is done using datetimestamp key.

high_value on all_tab_partitions for this table is like this,

TIMESTAMP' 2014-04-01 00:00:00'

TIMESTAMP' 2014-05-01 00:00:00'

I would like to know the piece of code to handle this TIMESTAMP issue using cursor or someother method,

Awaiting for the relays, thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 11 2016
Added on Aug 11 2016
10 comments
11,824 views