Re: Updating while joining
From: Saravanan <vsr.saravanan_at_gmail.com>
Date: Mon, 17 Aug 2009 06:41:49 -0700 (PDT)
Message-ID: <92db579b-d6e9-477c-8efe-af7ad605223d_at_w6g2000yqw.googlegroups.com>
On Aug 17, 6:00 pm, Ed Prochak <edproc..._at_gmail.com> wrote:
> 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
Date: Mon, 17 Aug 2009 06:41:49 -0700 (PDT)
Message-ID: <92db579b-d6e9-477c-8efe-af7ad605223d_at_w6g2000yqw.googlegroups.com>
On Aug 17, 6:00 pm, Ed Prochak <edproc..._at_gmail.com> wrote:
> 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
Thanks Ed. Received on Mon Aug 17 2009 - 08:41:49 CDT