Re: Read only transaction problem

"IANAL_VISTA" <IANAL_Vista_at_hotmail.com> wrote:
> cookie monster <nospam_at_nowhere.com> wrote in
> news:l5i0a1ladba0ocqabi4crieiev1266k4s8_at_4ax.com:
>
> > Hi,
> >
> > Using Oracle 9iR2
> >
> > I have this problem whereby I want to read from 10 tables that have FK
> > and the data is always changing. Therefore I use the option SET
> > TRANSACTION READ ONLY. Works fine. But now I want to read these 10
> > tables and create NEW tables with consistent data (using pl/sql). The
> > problem is I can't perform any insert of new data because I get an
> > error that the transaction is read only.
> >
> > Is there any way around this problem? I just want to create a copy of
> > these 10 tables with consisitent data. Any ideas??
> >
>
> Oracle ALWAYS guarentees a read consistent view of the data!

No, it doesn't. The default isolation level gives you inconsistent views of the data across the different statements within one transaction.

Xho

-- 
-------------------- http://NewsReader.Com/ --------------------
Usenet Newsgroup Service                        $9.95/Month 30GB