Re: FW: Oracle Options

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Thu, 19 May 2005 17:43:21 +0100
Message-ID: <7765c897050519094361b3b5e6@mail.gmail.com>

On 5/19/05, Hallas, John, Tech Dev <John.Hallas_at_gb.vodafone.co.uk> 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

Received on Thu May 19 2005 - 12:48:01 CDT