Splitting an Interval Partitioned Table
Is there any "easy" way to split an existing interval partitioned table? I have an interval partitioned table that is partitioned by day (NUMTODSINTERVAL(1,'DAY')) that I want to make interval partitioned by hour (NUMTODSINTERVAL(1,'HOUR')). It has existing data in it and as such existing partitions. Is there a simple way to split this existing table into hourly partitions or do I have to re-create the table as an hourly interval partitioned table and re-load all of the data?
Thanks,
Greg
Thanks,
Greg
0