On 9/6/05, Henslee, Jeff <jhenslee@(protected):
> Apologies - Here's are the error messages I was receiving -
Failed to extend rollback segment number 11
unable to extend rollback segment RBS10 by 128 in tablespace RBS.
A common cause of this is that a very large transaction that extended one
of your rollback segments to the point that it consumed most of
the space in the rollback tablespace.
Check the hwmsize in v$rollstat to see if that is the case.
You may want to assign as rollback segment in a separate tablespace
to transactions that cause this.
Certifiable Oracle DBA and Part Time Perl Evangelist
11+ years of trying to appear to know what I'm doing.