-
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
Success Consists of Getting Up Just One More Time Than You've Fallen Down
Be Blessed
-
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
Success Consists of Getting Up Just One More Time Than You've Fallen Down
Be Blessed
-
How about you answer my question?
-
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?
Success Consists of Getting Up Just One More Time Than You've Fallen Down
Be Blessed
-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|