Re: serializable isolation level behavior question

Thanks a lot to everyone to post the feedback. It is great that SR is already created and will be fixed soon. (I monitored the posts for first few days and forget about this issue so was not able to answer some questions.)
I just want to mention 1 point that it was mentioned many times in discussion that use "delete" statement instead of "truncate", I already post a seperate issue on that on google and opened a SR that truncate is taking 15-20 times longer than delete in 10.2.0.2 and so far oracle is not considering it as a bug but i am working with them on this issue.

Thanks
--Harvinder

On Oct 31, 12:14 pm, DA Morgan <damor..._at_psoug.org> wrote:
> Mark Townsend wrote:
> > hasta..._at_hotmail.com wrote:
> >> Mark Townsend wrote :
>
> >>>> I didnt think of opening an SR myself. But will open
> >>>> one (out of curiousity :-) if the OP confirms that he has
> >>>> not done so already.
>
> >>> When you do open one please post the number here (or send to me)
>
> >> SR 5913602.993
>
> > Development looked at this and agree it's a bug. Likely fix will be to
> > raise an error on the select after the truncate (as no roll back to
> > reconstruct the rows). No fixed by yet.Thanks.
> --
> Daniel A. Morgan
> University of Washington
> damor..._at_x.washington.edu
> (replace x with u to respond)
> Puget Sound Oracle Users Groupwww.psoug.org
Received on Tue Nov 07 2006 - 15:18:00 CST