Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Problems deleting data i got ORA-01562 and ORA-01650 errors

701532Oct 16 2009 — edited Oct 17 2009
Hi,

I got this to errors:
ORA-01562: failed to extend rollback segment number 14
ORA-01650: unable to extend rollback segment RB3 by 128 in tablespace ROLLBACK
When i been trying to delete some information of one table, this table has approximately 10 million of records because is information of 3 months.

My database are a Oracle 10g R2 10.2.0.4. I been researching the workaround but i don't have clear the issue, so if you know a solution for this i will appreciate.

Thanks,

Carlos Robles.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 14 2009
Added on Oct 16 2009
#general-database-discussions
4 comments
1,204 views