Re: TRUNCATE command

In article <31D5B9E5.59E5_at_cat.cat.cat>,

        HORSE <DOG_at_CAT.CAT.CAT> writes:
>I am using truncate to remove all the data from a table. The book says it
>is a DDL, not use rollback. But when I truncate a big table, it does.
>why! Thanks,

The book is correct ... Rollback segments are not directly touched, however, issuing a TRUNCATE does commit all pending transactions for the session ... this could be the rollback activity that you see.

Bill Received on Mon Jul 01 1996 - 00:00:00 CEST