-
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...