Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: How to avoid rollback during some INSERTs ?
Just use a bigger rollback segment!!!
In article <78571l$o58$1_at_smilodon.ecp.fr>,
riad_at_innocent.ANTI-SPAM.ORG wrote:
>
> Hi.
>
> I have some inserts (insert into toto values(...) select ....) that are pretty huge.
> usually, they explode the rollbacks (the table is indexed by two indexes, which
> make the charge heavier on the rollback).
> So what I do, I insert into this table by chunks of 10000 rows.
>
> But I would like to know if there is some simple way to avoiding using rollbacks
> during some inserts (like NOLOGGING avoid using logs) ????
>
> I don't care if the information would not be restorable, because if something wrong
> happens, I know eaxctly which rows I remove (referenced by a date).
>
> So any suggestions ?
>
> thanks in advance.
> Riad
> ----------------------------------------------
> To email, replace the "ANTI-SPAM.ORG" by "com"
> ----------------------------------------------
>
Frank Delisle
Consultant, Eds Québec
e-mail: francois.delisle_at_prosig.qc.ca
"Un problème sans solution n'est pas un problème"
-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Jan 21 1999 - 08:35:22 CST