Re: Bypass logging mechanism

read the manual and then use truncate table

regards,

--
Sybrand Bakker, Oracle DBA
<rrenzo_at_my-deja.com> wrote in message news:87e5fh$qu3$1_at_nnrp1.deja.com...
> How can I delete rows without letting Oracle log them?
> (ie. Truncate Table equivalent of MS Sql)
>
> When I delete all rows from a huge table; the rollback segment grows
> accordingly which is a waste of space (and time)...
>
> Thanx,
> Tony Cardalda.
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Fri Feb 04 2000 - 05:30:27 CST