Thanks for the question, Sina.
Asked: September 04, 2018 - 10:43 am UTC
Last updated: September 05, 2018 - 5:18 am UTC
Version: 11.2.0.4
Viewed 1000+ times
You Asked
Hi Tom,
How can I find partitions (PARTITION BY RANGE (DATE) INTERVAL (NUMTOYMINTERVAL(1,'MONTH')) of two tables within same date range (HIGH_VALUE) to merge those partitions? I have many tables and I am trying to create a script for it.
Thanks.
Best regards, Sina
and Connor said...
You can parse the HIGH_VALUE column from USER_TAB_PARTITIONS.
Here's a video I did on it
Let me know if you need more info
Rating
(1 rating)
Is this answer out of date? If it is, please let us know via a Comment