loading a large transactions

[ashley75]

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

[jmodic]

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

[sabita_ban]

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

[julian]

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

[sanju_dba]

Thanks Julian,

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