RE: URGENT - Can you coalesce a RBS tablespace?

When you say "unable" - what exactly do you mean? Are you getting an error message, or just a lack of response?

Not sure if you can coalesce an RBS tablespace off the top of my head - did you try it? Not sure if there would be any benefit from that - ideally your RBSs should all have the same extent sizes anyway so it shouldn't matter if the tablespace is coalesced or not.

-----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 9:55 AM 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

Privileged/Confidential Information may be contained in this message or attachments hereto. Please advise immediately if you or your employer do not consent to Internet email for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of this company shall be understood as neither given nor endorsed by it.

--

http://www.freelists.org/webpage/oracle-l Received on Tue Sep 06 2005 - 12:00:37 CDT