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!

Rollback segment error ORA-1628

456355Dec 19 2005 — edited Dec 21 2005

Hellow

Currently we are working on Oracle 8i database.The database contain spatial data around 10GB.We have a tablespace RBS containing 4 rollback segments. The issue is whenever we try to insert spatial data we get this error message (in the alert file)

ORA-1628: max # extents 121 reached for rollback segment R01
Failure to extend rollback segment 2 because of 1628 condition
FULL status of rollback segment 2 cleared.

I extended the size of RBS tablespace by adding another datafile, but still it doesn't help.

Also i found that RBS tablespace is marked as PERMANENT...it means the rollback data does not get flushed out periodically?Also Should this tablespace be temporary? How can i counter this problem?

Regards
Sam

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 18 2006

Added on Dec 19 2005

#general-database-discussions

7 comments

653 views