Re: Updating while joining

From: Tim X <timx_at_nospam.dev.null>
Date: Tue, 18 Aug 2009 20:15:41 +1000
Message-ID: <877hx15sxe.fsf_at_lion.rapttech.com.au>

Saravanan <vsr.saravanan_at_gmail.com> writes:

> Hi
> I am joining three tables a,b,c of which b and c are really large
> ( 20 million+ records). The join is running and in the mean time I am
> updating some rows in the table b and c. Will my join reflect the
> newly updated data in b and c?
> Will the join complete successfully?
>
> Thanks
> Saravanan

The join should complete, but it will not show the updated data if the join started prior to the updates being committed.

Have a look at the oracle concepts manual on Oracle's read consistency model.

-- 
tcross (at) rapttech dot com dot au

Received on Tue Aug 18 2009 - 05:15:41 CDT