From oracle-l-bounce@freelists.org Thu May 19 11:58:04 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j4JGw4u7019341 for ; Thu, 19 May 2005 11:58:04 -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 j4JGw04Z019335 for ; Thu, 19 May 2005 11:58:02 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 936C7195947; Thu, 19 May 2005 10:53:04 -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 28197-09; Thu, 19 May 2005 10:53:04 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 1C3C319571C; Thu, 19 May 2005 10:53:04 -0500 (EST) content-class: urn:content-classes:message MIME-Version: 1.0 Content-type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-MimeOLE: Produced By Microsoft Exchange V6.0.6603.0 Subject: FW: Oracle Options Date: Thu, 19 May 2005 16:46:02 +0100 Message-ID: <1C6E45ADB2EC324F9553E468ABFE0F63030F0AA0@UKWMXM04> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Oracle Options Thread-Index: AcVbufuuSs7bqr4eRCqX+5NfF2/C2gAIyNggAAPVJnAAJ1ZS8A== From: "Hallas, John, Tech Dev" To: X-OriginalArrivalTime: 19 May 2005 15:50:25.0796 (UTC) FILETIME=[7929EC40:01C55C8A] X-archive-position: 19934 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: John.Hallas@gb.vodafone.co.uk Precedence: normal Reply-To: John.Hallas@gb.vodafone.co.uk X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=0.2 required=5.0 tests=AWL autolearn=ham version=2.63 I understood that Partitioning works out at roughly =A310k per CPU. You can install EE without installing Partitioning so I still see it as = a an licensable option. If it is installed you owe Oracle the money basically, whether you are = using it or not. There is a means of removing partitioning though without a full = re-install (there is no de-install option within the installer). However = I cannot find details on Metalink (surprise, surprise) or even Google. It is definitely there though. I saw it only about 3 weeks ago. We = decided not to run it though as we were a bit concerned about the impact = on the existing system. Funnily enough even on a non partitioned installed installation there = are partitioned tables. Weird hey. John -----Original Message----- From: oracle-l-bounce@freelists.org = [mailto:oracle-l-bounce@freelists.org] On Behalf Of Thomas Day Sent: 18 May 2005 15:56 To: Oracle-L Subject: Re: Oracle Options No. If you need the data in the database then do a full export, drop the database, de-install Oracle, re-install Oracle with the options that you want, create a database and import your data. On the other hand, you might question why you want the options dropped. As I understand it, partitioning is available only with the Enterprise Edition (EE). If you have the Enterprise Edition, then you're paying for the Enterprise Edition whether or not you use partitioning. As always, your milage may varry. Research the options and find out if they are priced separately or are just a part of the particular edition of the Oracle that you are using. I'm not in procurement so I don't have these details handy. -- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-l