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 -> Re: Delete without Rollback ?

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

Original text of this message

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