How to avoid rollback during some INSERTs ?

From: El Gringo <read_at_the.signature>
Date: 20 Jan 1999 18:24:53 GMT
Message-ID: <78571l$o58$1@smilodon.ecp.fr>

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"

---

Received on Wed Jan 20 1999 - 12:24:53 CST