Re: delete w/o rollback segs???

From: <caramel98_at_my-deja.com>
Date: Tue, 04 Jan 2000 11:07:27 GMT
Message-ID: <84sk9a$sgm$1@nnrp1.deja.com>

Hi,

You ca use TRUNCATE TABLE table_name.
This will delete all rows.

You can't delete only some rows without using rollback segments. However, you can choose the rollback to use with the SET TRANSACTION USE ROLLBACK SEGMENT segment_name (or some thing like that)

In article <84rm9i$835$1_at_nnrp1.deja.com>, bmcgin9709_at_my-deja.com wrote:
> is it possible to delete from a table and not
use rollback segments?
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Jan 04 2000 - 05:07:27 CST