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

Thread: bulk insert

  1. #1
    Join Date
    Jun 2003
    Posts
    24

    Question bulk insert

    i want to insert a bulk files containing more than 2.5 million row but if I do and import I will face snapshot too old so I plan to break the files to smaller file......can anyone tell me what is the fatest way to insert bulk datas without facing this error.

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    use direct-insert

    insert /*+ APPEND */ select * from x

  3. #3
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    posibly with PARALLEL opt.
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

  4. #4
    Join Date
    Jun 2001
    Location
    California
    Posts
    124
    As suggested by other members (PARALLEL, HINT /*+APPEND ), you can also disable logging for the object(s). Ofcourse in order to get rid of snapshot 2 old error
    set transaction to

  5. #5
    Join Date
    Jun 2001
    Location
    California
    Posts
    124
    set transaction to "bigRollbackSegment"

  6. #6
    Join Date
    Jun 2001
    Location
    California
    Posts
    124
    Syntax
    ------
    SET TRANSACTION USE ROLLBACK SEGMENT RB_large

  7. #7
    Join Date
    Jun 2003
    Posts
    24
    I have tried using that method of insert with big rollback but I still hit with an error of snapwhot too old....Just to enquire if I can break the import to smaller files

  8. #8
    Join Date
    Jun 2001
    Location
    California
    Posts
    124
    Yes u can break the export file by using QUERY clause if it's just a matter of one table based on the primary key or any other criteria.

    HTH

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