Re: Allow 2 processes access to same table

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Wed, 22 Oct 2003 15:42:56 +0100
Message-ID: <3f969771$0$249$ed9e5944@reading.news.pipex.net>

"Tom" <tomNOSPAM_at_teameazyriders.com> wrote in message news:1066832636.87726.0_at_despina.uk.clara.net...
>
> "Jim Kennedy" <kennedy-downwithspammersfamily_at_attbi.net> wrote in message
news:Slwlb.609535$cF.279973_at_rwcrnsc53...
> > Just do it. What problem are you having? You should be able to access
the
> > table from multiple programs at a time.
> > Jim
>
> 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.

Unless you explicitly lock the table (you shouldn't) I suspect your SQL (assuming reasonable data volumes) and or application code.

Can you post the sql and table definitions etc?

-- 
Niall Litchfield
Oracle DBA
Audit Commission Uk

Received on Wed Oct 22 2003 - 09:42:56 CDT