Help!! Customer hasn't upgraded in 10 years!!

[oracleSQLdba]

This error in the event log. Oracle 7.3.4.5.0 on aix. Can someone tell me what I need to do. I've googled it and one response was to drop the rollback segment and recreate. I just want to verify first. BTW, how do you do that if that's the fix?

Thanks.

ALTER ROLLBACK SEGMENT "R02" STORAGE ( MAXEXTENTS 560)
Tue Jan 9 16:32:05 2007
ORA-1681 signalled during: ALTER ROLLBACK SEGMENT "R02" STORAGE ( MAXEXTENTS ...
Tue Jan 9 16:34:07 2007

 

[KenCunningham]

Not entirely certain, but I think 7.3.4 had a limit of 121 extents, so your maxextents value is invalid.

I don't mind people who aren't what they seem. I just wish they'd make their mind up.

 

[KenCunningham]

Hmmmm. Following up my statement above leads me to believe that the 121 maximum I mentioned isn't the case at version 7.3.4, since unlimited apparently became an option then. Apologies.

I don't mind people who aren't what they seem. I just wish they'd make their mind up.

 

[oracleSQLdba]

Here's what I believe / did. I found an Oracle old blog somewhere that indicated there was an init.ora param for unlimited that I could set for the rollback segments. Bouncing the db with this setting allowed me to make the change. The other suggestion in that posting said I could rebuild the rollback segments. ...Thank heavens this POS is on it's way out the door... of course we've been saying that for 2 years....