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!

ora-1628 max #extents reached for rollback segment

mail8mzApr 10 2014 — edited Apr 11 2014

Hi All,

I am use oracle 11.2, the undo management is set as Auto. The undo tablespace is set as fixed with about 32G. When I have a long transaction , the Ora-1628 appears. There is not much work in the transaction, just several 100k rows inserted into three tables with 1000k rows. Each row has about 50 bytes. Any suggestion?

Thanks in advance!

Locked Post

New comments cannot be posted to this locked post.

Locked on May 9 2014

Added on Apr 10 2014

#general-database-discussions

9 comments

1,246 views