From oracle-l-bounce@freelists.org Thu Oct 6 06:58:30 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j96BwTZc009642 for ; Thu, 6 Oct 2005 06:58:29 -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 j96BwEvX009579 for ; Thu, 6 Oct 2005 06:58:14 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 800361F465C; Thu, 6 Oct 2005 06:57:27 -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 24045-05; Thu, 6 Oct 2005 06:57:27 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 0A34E1F466A; Thu, 6 Oct 2005 06:57:26 -0500 (EST) X-MimeOLE: Produced By Microsoft Exchange V6.5.7226.0 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by Ecartis Subject: RE: Rule of thumb for new schema vs. new database? Date: Thu, 6 Oct 2005 07:55:28 -0400 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Rule of thumb for new schema vs. new database? thread-index: AcXJ8T45/GyY0oGqRwOKCu8M5a9OtQAeq72w From: "Mercadante, Thomas F (LABOR)" To: , "Oracle-L" X-OriginalArrivalTime: 06 Oct 2005 11:55:33.0048 (UTC) FILETIME=[DB103B80:01C5CA6C] X-archive-position: 26445 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: Thomas.Mercadante@labor.state.ny.us Precedence: normal Reply-To: Thomas.Mercadante@labor.state.ny.us 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-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Level: X-Spam-Status: No, hits=-3.5 required=5.0 tests=AWL,BAYES_00 autolearn=ham version=2.63 Brian, Something that was not mentioned by everyone and what I think is the most important question to ask has to do with recoverability. If you need to roll one schema back for a data recovery reason, then the planning takes on another whole level of thought. In my mind, doing individual tablespace recoveries for this reason (if you separating each schema into separate tablespaces) is just not worth it. I prefer creating a new database instance on the same machine. Also, if these are canned applications separate instances gives you more flexibility if these applications are tied to specific release levels of Oracle. Right now I am unable to move to Oracle 10g for some of our databases because our current level of Curam (our current software du jour) is not certified against it. But we have other applications that can move to 10g. To me, it is not a big deal to create another instance. Sure it consumes more hardware resources, but it makes recovery a lot easier. Tom -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of BP Sent: Wednesday, October 05, 2005 5:09 PM To: Oracle-L Subject: Rule of thumb for new schema vs. new database? Hi Again, I have a meeting tomorrow with one of our project managers who is going to request a new schema or database. He wants my advice on which is best for his needs. Now...as I've said before I'm a neophyte DBA and do know the difference between a schema and a new database. I'm inclined to suggest just a new schema, but now I'm wondering to myself what kind of 'rule of thumb' is there is for this kind of decision. When would it be preferable to create a new db vs. just a schema in an existing db? Thanks for you help. Brian Peasey -- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-l