Re: Allow 2 processes access to same table

Tom wrote:

>Hi,
>
>We currently have a need, to drop obsolete data, to allow some sql scripts to access tables while the application JVM is also
>accessing these tables.
>
>How do i allow both sessions to alter the data in the same tables at the same time? I know that they will not effect each other as
>the data they will be effecting is seperated by a good few years but how can i let oracle know this?
>
>I've been looking and think that this is possible with the ISOLATION_LEVEL parameter in my session but i am not certain?
>
>This work is needed on 8.1.5 and there is not an option to stop the JVM during this time.
>
>thanks
>
>Tom
>
>

Obviously you have not read any documentation on the Oracle database: On its architecture
and concepts. I'd suggest you start there.

What you need to do to accomplish you goal is absolutely nothing. What you need to do to avoid
making a huge mess is learn about the tool you are using.

-- 
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)