Home » RDBMS Server » Server Administration » Rollback segment error.
Rollback segment error. [message #33655] Mon, 25 October 2004 00:43 Go to next message
MBB
Messages: 16
Registered: September 2004
Junior Member
Hi,

I have a table with 1lakh records. While inserting
all these records into another table i am getting
the following error.

"unable to extend rollback segment R07 by 640 in
tablespace RBS"

Can anyone help me wht could be the problem and how
to get rid of this error.

Thanx in advance.

Report message to a moderator

Re: Rollback segment error. [message #33658 is a reply to message #33655] Mon, 25 October 2004 04:50 Go to previous message
shoblock
Messages: 325
Registered: April 2004
Senior Member
- increase the tablespace used by the rollback segment, and make sure that the RBS maxextents is high enough

or

- insert less rows, and commit between

Report message to a moderator

Previous Topic: DB instance getting terminated automatically
Next Topic: How create dump in Ora9 for unpack in Ora8i
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Feb 03 14:18:19 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.