PARTITION_FREQUENCY : DAILY, MONTHLY
PARTITION_NAME_FORMAT : P{yyyy}{mm}{dd}, P{YYYY}{MM}
FIRST_PARTITION_NAME : P20100101

BEGIN
  pkg_partition_manager.p_create_missing_partitions (
    p_owner       => 'DWH',
    p_table_name  => 'SALES' -- daily partitoned table
  );
END;
/

ALTER TABLE DWH.SALES split partition PMAX at ( to_date('03-JAN-2010 00:00:00')) INTO          
(partition P20100102 ,partition PMAX) UPDATE global indexes;
ALTER TABLE DWH.SALES split partition PMAX at ( to_date('04-JAN-2010 00:00:00')) INTO          
(partition P20100103 ,partition PMAX) UPDATE global indexes;
ALTER TABLE DWH.SALES split partition PMAX at ( to_date('05-JAN-2010 00:00:00')) INTO
(partition P20100104 ,partition PMAX) UPDATE global indexes;