standards
gh, August 10, 2017 - 5:28 am UTC
.and don't forget to switch the src and dst
Thanks
BC, August 10, 2017 - 11:59 am UTC
Thank you Connor, appreciate the quick response.
And to GH for pointing out the misplaced src and dst.
-BC
need sample query for Merge script for multiple partition parallel processing
Jagdish, August 23, 2017 - 11:37 am UTC
Hi
You are updating data in a partitioned table for multiple partitions at one go.
but you have provided merge script for serial partition
how will your merge script be modified for multiple partitions.
what will be your l_sql_stmt for the run task ?
To execute the below script
dbms_parallel_execute.run_task( 'partition_task',
l_sql_stmt,
dbms_sql.native,
parallel_level => 10 );
Kindly provide inputs
Thanks
jags