Interval Partitioned to Range. Created Daily Partitions from Monthly Part.
Hi,
We have a huge table with millions of rows.
I need to change it to a Range Partitioned.
CREATE TABLE A
(
a NUMBER,
CreationDate DATE
)
PARTITION BY RANGE (CreationDate)
INTERVAL ( NUMTODSINTERVAL (30, 'DAY') )
(PARTITION P_FIRST
VALUES LESS THAN (TIMESTAMP ' 2001-01-01 00:00:00'))
Now as Table A is Interval Partitioned Monthly as shown above.
WHEREAS Partition Key is DATE.
So when I create the new Range Partitioned Table and use a script we already have to create partitions in advance. It uses the Partition Key as Date and creates Daily Partition.
WHAT are the consequences if I apply daily partitions instead of the monthly ones on this table after converting it to a Range Partitioned table.
Please suggest..