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

On Aug 17, 7:02*am, Saravanan <vsr.sarava... (AT) gmail (DOT) com> wrote:
Two sessions, so two views of the data. If the join started before the
update is committed, then it will NOT see the update.

Do you understand the relational database concept of transactions?
Oracle is not a file system. It is a Relational Database management
System (RDBMS).
Ed

On Aug 17, 6:00*pm, Ed Prochak <edproc... (AT) gmail (DOT) com> wrote:
Thanks Ed.

Saravanan <vsr.saravanan (AT) gmail (DOT) com> writes:

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