Merge Basics
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: Merge Basics

  1. #1
    Join Date
    Aug 2002
    Posts
    176

    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

  2. #2
    Join Date
    Jan 2004
    Posts
    162
    Why would incremental COMMIT help to avoid snapshot too old?

  3. #3
    Join Date
    Aug 2002
    Posts
    176
    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

  4. #4
    Join Date
    Jan 2004
    Posts
    162
    How about you answer my question?

  5. #5
    Join Date
    Oct 2001
    Location
    Berlin, Germany
    Posts
    97
    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

  6. #6
    Join Date
    Jul 2002
    Location
    Northampton, England
    Posts
    612
    But commiting frequently won't prevent a snapshot too old error, that is what padders is saying. Ask Tom, he'll tell you.

  7. #7
    Join Date
    Aug 2002
    Posts
    176
    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

  8. #8
    Join Date
    Jan 2004
    Posts
    162
    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
  •  


Click Here to Expand Forum to Full Width