loading a large transactions

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

Those two error codes mean you were running out of space in your rollback tablespaces. So increase your tablespace.

If you are using some script to insert data, then add commit statements as frequently as possible within the script ie inbetween insert statements.

Now this is a perfect candidate for ALTER SESSION ENABLE RESUMABLE; If you are on 9i of course...

Thanks Julian,

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