Re: Delete without Rollback ?

From: Marcos Andres Vera Yañez <mvera_at_rdc.cl>
Date: Thu, 06 Aug 1998 08:33:08 -0500
Message-ID: <35C9B094.5BACFEA9@rdc.cl>

Hi :
You can't do that. This work style is the base to Oracle Engine. You have only one exception, the "truncate" statement. With this command you can
delete all rows from a table, but you can't choose them. By

John Finn wrote:

> Does anyone know how to Delete without Rollback transaction overhead?
>
> "DELETE FROM TABLE1 WHERE ..."
>
> and no transaction overhead, rollback, commit ...
>
> thanks
> jfinn
>

--

---

Marcos Vera Yanez
Oracle Database Adminstrator
Email : mvera_at_rdc.cl, Phone : 56-2-4406953

"Smell the Flower While you can"

---

Received on Thu Aug 06 1998 - 08:33:08 CDT