I have a huge partition table with almost 1 billion records which is partitioned by date range i.e. from 2015-01-01 to 2017-12-01 with 1-36 partitions. There is a requirement of adding data to this table prior 2015 i.e. adding data of the year 2014. So i tried doing the below
ALTER PARTITION FUNCTION partition_function_name()
SPLIT RANGE ( boundary_value ) };
But this can be done for adding the partitions after 2017 and I want to add it before 2015. Is there a way I can add the partitions prior 2015 efficiently without moving the existing data as the data is very huge.