-
dropping partitions using date function
I am trying to create a script that drops partitions, which are older than
"N' days.
My partitions names are always in this format "P_2010_10_20" (P_YYYY_MM_DD)
I want to do something like this, but the syntax is not correct:
select partition_name from user_tab_partitions where table_name = 'XXX'
and partition_name < (sysdate - Ndays)
Can somebody help me with the correct syntax.
Thanks to all who answer
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
|