Do I have to insert manually number of partition during the recreation process? For example: let's say I have to implement
partitioning on some existing history table according to month key (partition by month). Does it mean that first of all I must manually calculate how years (and months) of data the table has? And only then insert the calculated partition number? Is there any way to do it automatically?
In reference to the manual insert of number of partition during the recreation process,
Yes you can do it automatically if you have Oracle 11.
Here is what you need to do:
Find the lowest date in the table. Suppose the earliest date is 2001-04-15.
