Re: Delete Query

["Cullina, Adam" <cullinaa@UMSYSTEM.EDU>]

If you mean process a delete so that it doesn't even fill up the rollback
segments (which is why some large deletes are very slow), the answer is
probably no.  It is possible to build a table in oracle that doesn't use
rollbacks w/deletes, but you can't do it unless the table was created in
that manner (and very few are).

Adam

-----Original Message-----
From: Jamin Philippe [mailto:PJamin@SLTC-FR.COM]
Sent: Thursday, December 07, 2000 2:21 AM
To: SQR-USERS@list.iex.net
Subject: Delete Query


Hello All,

SQR V3, Oracle V7

Is there a means of do a DELETE Query without using the possibility of
Rollback ?
I am sure to will suppress my data.

 thank you

---
Philippe Jamin
SLTC - Société Lyonnaise de Transports en Commun
Direction des Services Techniques - GMAO
41, rue de la Poudrette - 69120 Vaulx-en-Velin
* 04 78 71 83 16 - Fax : 04 78 71 83 56
pjamin@sltc-fr.com