Need to insert 2 different set of data into single table

[harshadaz]

Hi,

I have a requirement where I need to insert different set of data into emp table at the same time. e.g process A will start inserting data into EMP for condition='Y' and process B will insert data into EMP for condition='N. Both the process will trigger at the same time. I have done this using exclusive lock but it waits for process A to complete and the load data for process B. Is ther any way where I can load data into EMP parallely for both conditions. May be lading data into different partitions at the same time?

[Luuk]

" I have done this using exclusive lock"

This, of course, stops doing 2 (or more) things at the same time.

Loading data into 1 table with 2 or more processes might anyway be slower than starting the load of the second batch after the first one is finished. (depending on how many indexes are defined)