Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: serializable isolation level behavior question

Re: serializable isolation level behavior question

From: hpuxrac <johnbhurley_at_sbcglobal.net>
Date: 19 Oct 2006 09:24:30 -0700
Message-ID: <1161275070.399495.122890@m7g2000cwm.googlegroups.com>

Bob Jones wrote:
> >> Are we still talking about TRUNCATE? Serializing it is like serializing
> >> drop table. It does not make sense. I don't know what part was I not
> >> clear about.
> >
> > You have been very clear, but you are missing the point.
> >
> > A serializable transaction must not get different results when issuing the
> > same query twice. Period.
> >
>
> Again, truncate is not a query, it is not even a dml.
>

Why not go back and read the original posting and the questions posed in it instead of repeatedly posting items not related?

The query was a SELECT in the serializable transaction.

After that you go off on some kind of unrelated rant. Received on Thu Oct 19 2006 - 11:24:30 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US