Re: Allow 2 processes access to same table

> but both applications have to modify the table at the same time - I'm worried about locks etc as the sql takes around 10 hours to
> run and i can't have the JVM waiting on the table for that long.

As long as they both don't modify the same rows of data, then one process won't lock out the other. That is how Oracle's transaction processing works. Oracle locks on the row level, not the table or block level like other RDMBS vendor's products.

If they are modifying the same rows of data, then you'll surely want the rows locked to transaction isolation.

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"