how to insert millions of records may be more in partitions.

select partition_name, compression, num_rows / nullif(blocks,0) rows_per_blk
from dba_tab_partitions
where table_name = 'SALES_P'
order by partition_position; 2 3 4

PARTITION_NAME COMPRESSIO ROWS_PER_BLK
-------------------- ---------- ------------
SALES_P_JAN ENABLED
SALES_P_FEB ENABLED
SALES_P_MAR ENABLED
SALES_P_DEC ENABLED


This is my table (sales_p) with 4 partitions , i need to insert millions of rows in each one
please send me any sql code to do to so.

insert into sales_p partition ( SALES_P_JAN  )
select ...

insert into sales_p partition ( SALES_P_FEB )
select ...

insert into sales_p partition ( SALES_P_MAR )
select ...

insert into sales_p partition ( SALES_P_DEC )
select ...