Need help with partitions. Will the data in the NORANGE partitions automatically be moved to a new Partition that is created with an Alter table command ?
Thanks in advance
Adding the new partition is done through MODIFY PRIMARY INDEX(...) statement, and once the primary idex is changed the data will be re-distributed accordingly. So yes the data present in NORANGE partition should be redistributed to the new related partitions.
I guess you are aware of the fact that only the RANGE partitions at the 'ends' of you partition scheme can be altered, dropped/added.