Re: URGENT - Can you coalesce a RBS tablespace?

Try setting the OPTIMUM parameter, which will reduce the size of yr segment after finishing the transaction. That can help you to get through.  But if the transactions are long, they can generate 1555 erros in yr trace files.
 Look for this too.
 Regards - Chirag

 On 9/6/05, Mercadante, Thomas F (LABOR) < Thomas.Mercadante_at_labor.state.ny.us> wrote:
>
> Jeff,
>
> Have you shrunk the existing rollback segments? You may have some that
> are huge in size. You can shrink them and this will free up space in
> the RBS tablespace.
>
> Tom
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Henslee, Jeff
> Sent: Tuesday, September 06, 2005 12:55 PM
> To: Oracle-L Freelists
> Subject: URGENT - Can you coalesce a RBS tablespace?
>
> We seem to be having troubles with some of our RBS segments. We are
> unable to create new segments or extend existing ones. This is an
> unusual pattern and we're trying to find a way to get people back
> working again without having to add a datafile to the RBS area (if at
> all possible) or restart the instance.
>
> Options please?
>
> Thank you.
>
> Jeffrey C. Henslee (Chico)
> Six Sigma Green Belt
> Wausau Window and Wall Systems
> (715) 846-3196
> mailto:jhenslee_at_wausauwindow.com
>
> --
> http://www.freelists.org/webpage/oracle-l
> --
> http://www.freelists.org/webpage/oracle-l
>

--
http://www.freelists.org/webpage/oracle-l