Re: isolation level serializable

From: Chuck <skilover_nospam_at_bluebottle.com>
Date: Thu, 22 Mar 2007 13:45:13 GMT
Message-ID: <JLvMh.12574$e47.2907@trnddc05>

Vladimir M. Zakharychev wrote:

>
> I think that some unforeseen/unexpected implicit commit happens while
> the copying is en route and Oracle automatically reverts isolation
> level back to default READ COMMITTED. Without seeing actual code it's
> impossible to tell where this commit might be issued. For example,
> TRUNCATE is actually DDL and it implicitly commits, so if you do any
> truncates inside the copy loop this might be the cause.
>

That's pretty much what I'm looking for at this point. Does EXECUTE IMMEDIATE do an implicit commit? I didn't think it did. Received on Thu Mar 22 2007 - 08:45:13 CDT