Re: Partioning Question

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Wed, 01 Dec 1999 12:36:04 -0500
Message-ID: <e1na4sonb4isngncn58pep3k9fn7la6550@4ax.com>

A copy of this was sent to FrankS
<northernsnowNOnoSPAM_at_worldnet.att.net.invalid> (if that email address didn't require changing) On Wed, 01 Dec 1999 08:23:52 -0800, you wrote:

>I am using enterprise edition as shown below. Any thing
>else?
>
>Thanks!
>Frank
>
>
>SQL> select * from v$version;
>
>BANNER
>------------------------------------------------------------
>----
>Oracle8 Enterprise Edition Release 8.0.5.2.1 - Production
>PL/SQL Release 8.0.5.2.0 - Production
>CORE Version 4.0.5.0.0 - Production
>TNS for DEC OSF/1 AXP: Version 8.0.5.0.0 - Production
>NLSRTL Version 3.3.2.0.0 - Production
>
>SQL>
>

You need to have the partitioning option installed, eg -- my sqlplus banner is:

$ sqlplus scott/tiger

SQL*Plus: Release 8.0.3.0.0 - Production on Wed Dec 1 12:37:35 1999 (c) Copyright 1997 Oracle Corporation. All rights reserved. Connected to:

Oracle8 Enterprise Edition Release 8.0.3.0.0 - Production With the Partitioning and Objects options PL/SQL Release 8.0.3.0.0 - Production

SQL> select * from v$option;

PARAMETER

---

VALUE

---

Partitioning
TRUE Objects
TRUE Parallel Server
FALSE
>
>* Sent from AltaVista http://www.altavista.com Where you can also find related Web Pages, Images, Audios, Videos, News, and Shopping. Smart is Beautiful

--
See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Wed Dec 01 1999 - 11:36:04 CST