Altering a table with interval partition from monthly to dailyHi.
Hi
I am using oracle 11.2.0.4 and I am considering switching a table from interval monthly partitions to interval daily partitions. I did a quick test on a test table and it seems to be working as expected.
My only concern is - is doing that (alter table set interval) going to have any negative consequences in terms of administering this table. I don't see anything, but I wanted to check before we went live with that
TIA
Gene