I want to change the partitioning on a partitioned table. How do I don this?
I goofed when I created a partitioned table and defined the structure for the partitions
PARTITION ld_data_012014_p VALUES LESS THAN (TO_DATE('2-1-2014', 'DD-MM-YYYY')) ,
PARTITION ld_data_022014_p VALUES LESS THAN (TO_DATE('3-1-2014', 'DD-MM-YYYY')) ,...
Used the date format of DD-MM-YYYY but the value less than is expecting MM-DD-YYYY
Millions of rows have been inserted into the table.
What I am thinking of doing is
creating new partitions on the table
PARTITION ld_data_012014_p2 VALUES LESS THAN (TO_DATE('2-1-2014', MM-DD-YYYY')) ,
PARTITION ld_data_022014_p2 VALUES LESS THAN (TO_DATE('3-1-2014', MM-DD-YYYY')) ,...