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
Those two error codes mean you were running out of space in your rollback tablespaces. So increase your tablespace.
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
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...
ALTER SESSION RESUMABLE is really a great info for me ...made my life better...
Click Here to Expand Forum to Full Width