Merge Basics

Hi ,

Does Merge run as one single command?(i.e) if I have 10 million records being acted on in the merge , Can I commit only at the end? or is there any option like in import having commit=y to specify commit after the array of records gets loaded?

This in case to avoid snapshot too old error.

Please guide .
Thanks

Why would incremental COMMIT help to avoid snapshot too old?

hi padders,

thanks for your reply , But how do we implemet it in merge or with the procedure calling the merge, pls do guide

thanks john

How about you answer my question?

Quote:

---

Originally posted by padders
Why would incremental COMMIT help to avoid snapshot too old?

---

a commit is the end of a transaction. a snapshot to old error is because of a too small roll back segment for one transaktion.

I hope this is helping you ...

chris

But commiting frequently won't prevent a snapshot too old error, that is what padders is saying. Ask Tom, he'll tell you.

Hi guys ,

Sorry I had misinterpretted my question Like problems of not snap shot too old but problems like rollback segment running out of space. Is there a incremental commit feature in merge?

No. You could possibly simulate in PL/SQL with BULK COLLECT .. LIMIT into a persistent collection type followed by MERGE INTO .. USING (SELECT * FROM TABLE (...)).

However the CORRECT thing to do here is to appropriately size ALL your rollback segments.