Re: Updating while joining

From: Tim X <>
Date: Tue, 18 Aug 2009 20:15:41 +1000
Message-ID: <>

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

Original text of this message