Re: Updating while joining
From: Ed Prochak <edprochak_at_gmail.com>
Date: Mon, 17 Aug 2009 06:00:04 -0700 (PDT)
Message-ID: <edcb8fe9-7ef6-4f09-8b4c-496421322615_at_c29g2000yqd.googlegroups.com>
On Aug 17, 7:02 am, Saravanan <vsr.sarava..._at_gmail.com> wrote:
> 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
Date: Mon, 17 Aug 2009 06:00:04 -0700 (PDT)
Message-ID: <edcb8fe9-7ef6-4f09-8b4c-496421322615_at_c29g2000yqd.googlegroups.com>
On Aug 17, 7:02 am, Saravanan <vsr.sarava..._at_gmail.com> wrote:
> 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
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
Received on Mon Aug 17 2009 - 08:00:04 CDT