-
Partition High Value
I have a table that is partitioned by month. I only want 3 months worth of data in it. I am trying to write a program that identifies the paritions that hold values older then 3 months and drop them. This script would run once a month.
When I try to use the high value column in dba_tab_partitions it is long and I can't sort on it to get the last three. Any ideas how I could get the partition name of the partitions that I want dropped?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|