From oracle-l-bounce@freelists.org Thu May 19 12:48:01 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j4JHm1wO025103 for ; Thu, 19 May 2005 12:48:01 -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 j4JHm14Z025099 for ; Thu, 19 May 2005 12:48:01 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 43C88195376; Thu, 19 May 2005 11:45:10 -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 05499-09; Thu, 19 May 2005 11:45:10 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id BF8A9195554; Thu, 19 May 2005 11:45:09 -0500 (EST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:references; b=lSUtDBAC5bojw16y9BG+mxWmkfCGb4fBNdBYqhQBjCXnnY73Urv0spUy52RDTLqw/IlLkYNd3Q+fpHBnz5aukyuvV9bR3anT8x50/CU7J+yB5GPIVmfvjpCaLYV45b1d+ox7Usp2F7R3iGPIayMl0MuUjMHWEjhu5lkT+raI5QU= Message-ID: <7765c897050519094361b3b5e6@mail.gmail.com> Date: Thu, 19 May 2005 17:43:21 +0100 From: Niall Litchfield To: John.Hallas@gb.vodafone.co.uk Subject: Re: FW: Oracle Options Cc: oracle-l@freelists.org In-Reply-To: <1C6E45ADB2EC324F9553E468ABFE0F63030F0AA0@UKWMXM04> Mime-Version: 1.0 Content-type: text/plain References: <1C6E45ADB2EC324F9553E468ABFE0F63030F0AA0@UKWMXM04> Content-Transfer-Encoding: 8bit X-archive-position: 19943 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: niall.litchfield@gmail.com Precedence: normal Reply-To: niall.litchfield@gmail.com 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.0 required=5.0 tests=AWL,LINES_OF_YELLING autolearn=ham version=2.63 On 5/19/05, Hallas, John, Tech Dev wrote: > > Funnily enough even on a non partitioned installed installation there = > are partitioned tables. Weird hey. > Indeed SYS>select banner from v$version; BANNER ---------------------------------------------------------------- Oracle Database 10g Release 10.1.0.4.0 - Production PL/SQL Release 10.1.0.4.0 - Production CORE 10.1.0.4.0 Production TNS for 32-bit Windows: Version 10.1.0.4.0 - Production NLSRTL Version 10.1.0.4.0 - Production 5 rows selected. /* std edition */ SYS>select comp_name 2 from dba_registry; COMP_NAME ---------------------------------------- Oracle Ultra Search Oracle Enterprise Manager Oracle Text Oracle XML Database Oracle interMedia Oracle Expression Filter Oracle Workspace Manager Oracle Data Mining Oracle Database Catalog Views Oracle Database Packages and Types JServer JAVA Virtual Machine Oracle XDK Oracle Database Java Packages /* No AQ, No Partitioning etc */ SYS>select object_type,count(*) 2 from dba_objects 3 group by object_type; /* edited only to remove irrelevant stuff */ OBJECT_TYPE COUNT(*) ------------------- ---------- INDEX PARTITION 80 LOB PARTITION 2 QUEUE 23 TABLE PARTITION 73 SYS> -- Niall Litchfield Oracle DBA http://www.niall.litchfield.dial.pipex.com -- http://www.freelists.org/webpage/oracle-l