Re: URGENT - Can you coalesce a RBS tablespace?

On 9/6/05, Henslee, Jeff <jhenslee_at_wausauwindow.com> wrote:
> Apologies - Here's are the error messages I was receiving -
>
> ORA-01562 Failed to extend rollback segment number 11
> ORA-01650 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.

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
11+ years of trying to appear to know what I'm doing.
--
http://www.freelists.org/webpage/oracle-l