From oracle-l-bounce@freelists.org Tue Sep 6 12:00:37 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j86H0a11003092 for ; Tue, 6 Sep 2005 12:00:36 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j86H0XIP003075 for ; Tue, 6 Sep 2005 12:00:33 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id B78301E90DA; Tue, 6 Sep 2005 12:00:29 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 21459-08; Tue, 6 Sep 2005 12:00:29 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 3BD7B1E9655; Tue, 6 Sep 2005 12:00:29 -0500 (EST) X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.326 Priority: normal Content-Class: urn:content-classes:message MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by Ecartis Subject: RE: URGENT - Can you coalesce a RBS tablespace? Date: Tue, 6 Sep 2005 10:00:13 -0700 Message-ID: <04DDF147ED3A0D42B48A48A18D574C4502361537@NT15.oneneck.corp> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: URGENT - Can you coalesce a RBS tablespace? thread-index: AcWzA62IEVJTw3MIQoSYuji1umihTwAAHzIQ From: "Allen, Brandon" To: , "Oracle-L Freelists" X-archive-position: 25051 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: Brandon.Allen@OneNeck.com Precedence: normal Reply-To: Brandon.Allen@OneNeck.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=-4.8 required=5.0 tests=AWL,BAYES_00 autolearn=ham version=2.63 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@freelists.org [mailto:oracle-l-bounce@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@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