Re: Delete without Rollback ?

From: Peter Chan <chanp_at_nortel.ca>
Date: Wed, 05 Aug 1998 10:43:38 -0400
Message-ID: <35C86F9A.54F2@nortel.ca>

I don't think there is another way to do this.

You are probably running into errors where it will complain that it cannot extend the rollback segment.

I think what you will have to do is create a huge rollback segment.

Then set your transaction to use the huge rollback segment by

  set transaction use rollback segment <segment name>

Then try the delete again.

I hope this helps.

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

--

---

PETER CHAN, Northern Telecom
PHONE: (613) 763-9096 FAX: (613) 763-4408 EMAIL: chanp_at_nortel.ca

---

Received on Wed Aug 05 1998 - 09:43:38 CDT