Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Allow 2 processes access to same table
Tom wrote:
>"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.
>
>thanks
>
>
Not to be insulting, but I'm worried that the primary reason it is
taking 10 hours is that you
are totally clueless about the tool you are using. Stop looking for
problems beyond your
own understanding of Oracle which is obviously minimal and hire a
consultant to help you
with your project and teach you Oracle basics.
-- Daniel Morgan http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp damorgan_at_x.washington.edu (replace 'x' with a 'u' to reply)Received on Wed Oct 22 2003 - 10:31:03 CDT