Re: FW: Oracle Options
- From: Niall Litchfield <niall.litchfield@xxxxxxxxx>
- To: John.Hallas@xxxxxxxxxxxxxxxxx
- Date: Thu, 19 May 2005 17:43:21 +0100
On 5/19/05, Hallas, John, Tech Dev <John.Hallas@xxxxxxxxxxxxxxxxx> 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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
