Truncate does NOT allow rollback. delete does. truncate changes the
storage and does not "erase the blocks"
Jim
"Matthias Rogel" <rogel_at_web.de> wrote in message
news:atcubv$12io17$1_at_ID-86071.news.dfncis.de...
> Vladimir M. Zakharychev wrote:
> > "Joel Garry" <joel-garry_at_home.com> wrote in message
> >
> >
> >>Users view of sys.*$ is confused, because DDL is not transaction
> >>based.
> >
> >
> > Hmm... Are you saying that DDL violates ACID properties of the
> > database? Or do I read this sentence incorrectly?
> >
>
> well, what is your opinion to the following:
>
> as Jonathan Lewis pointed out, a truncate at first implicitly performs a
> commit.
> After the commit it still may fail (in case another user has
> meanwhile performed a lock on the table)
>
> in my opinion, the A in ACID is violated
> A = atomicity
>
> Matthias
>
>
>
Received on Fri Dec 13 2002 - 10:31:35 CST
