We have a table that has to store around 80-100 million records. The table is partitioned by a column called Market Code. There are 30 partitions each corresponding to one MRKT_CD.
The source of this table is a join between 3-4 other tables. We are loading this table through SQLPLUS in UNIX script.The script basically iterates through a list of 30 market codes and loads data partition by partition.
My question is, is there a way to trigger these inserts in parallel since they are all going to write into different partitions? Currently each insert is sequential.
I'm not too sure how DB specific my question is so I'm going to post this question on the UNIX forum too.