Re: delete w/o rollback segs???

From: Gary Waldrom <garyw_at_amonra-insight.com>
Date: Mon, 10 Jan 2000 08:12:11 -0000
Message-ID: <E47927FC0A9CD3119D090000216DAFF5024EE2@THOTH>

Truncate is fine as long as you wish to delete ALL the data from the table, there is no WHERE clause to a TRUNCATE

Gary Waldrom
Amonra Insight Ltd.
Authors of Q-file IT Quick Reference Guides http://www.q-file.com

-----Original Message-----
From: Michael Puente [mailto:mcpuente_at_cis.com.ph] Posted At: Tuesday, January 04, 2000 8:45 AM Posted To: server
Conversation: delete w/o rollback segs??? Subject: Re: delete w/o rollback segs???

yes...truncate table table_name;

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.
Received on Mon Jan 10 2000 - 02:12:11 CST