I have a requirement where i need to do a parallel insert into 8 tables using dbms_parallel_execute. The requirement is as below:
create chunks by SQL: select distinct level_key, level_key from chunk_table.
chunk_table would be as below:
- - - -
I need to do a parallel insert into all 8 tables by mentioning parallel level 8. My run_task SQL should be as below
insert into table_name select /*+ parallel(stg, 8) */ from staging_table stg where level_key=:start_id
All the 8 different sales level of data is in the staging_table. Based on level_key, the data should be inserted into respective tables.
Is this possible? It at all, please give some ideas.