Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Bypass logging mechanism

Bypass logging mechanism

From: <rrenzo_at_my-deja.com>
Date: Fri, 04 Feb 2000 09:17:38 GMT
Message-ID: <87e5fh$qu3$1@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 - 03:17:38 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US