loading a large transactions
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: loading a large transactions

  1. #1
    Join Date
    Jan 2002
    Posts
    474
    I tried to insert over milllion row into a table and I got this error message:

    ora-01562, ora-01650 failed and unable to extend rollback segment

    should I add more rollback segement and rerun or increase the rollback tablespace ???

    My rollback is currently optimaL 5M and I have 8 rollback segements

    Thanks

  2. #2
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Those two error codes mean you were running out of space in your rollback tablespaces. So increase your tablespace.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  3. #3
    Join Date
    Jan 2002
    Posts
    65
    If you are using some script to insert data, then add commit statements as frequently as possible within the script ie inbetween insert statements.
    Sabitabrata

  4. #4
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Now this is a perfect candidate for ALTER SESSION ENABLE RESUMABLE; If you are on 9i of course...


  5. #5
    Join Date
    Jan 2002
    Posts
    59

    Smile

    Thanks Julian,

    ALTER SESSION RESUMABLE is really a great info for me ...made my life better...

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