Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: HELP - Partitioned option not enabled

Re: HELP - Partitioned option not enabled

From: salu Ullah <salu_ullah_at_hotmail.com>
Date: Mon, 13 Nov 2000 21:40:36 GMT
Message-Id: <10679.121939@fatcity.com>


Hello Rajanish

We do have an enterprise version, which is working fine on production box, i mean with partitioned option. I just installed same on test box but unable to create partiotioned table.
when i connect to test box it show as follows:

Connected to:
Oracle8 Enterprise Edition Release 8.0.5.0.0 - Production PL/SQL Release 8.0.5.0.0 - Production

when i connect to prod box it show:

Connected to:
Oracle8 Enterprise Edition Release 8.0.5.0.0 - Production With the Partitioning option
PL/SQL Release 8.0.5.0.0 - Production

I just can't remember what i did to get partiotioned optioned enabled on prod. Do i have to install it from CD or is there any command? There is a table which i cant recall that shows all the options installed.

Thanking in advance

Salu

>From: Joshi Rajanish <dbaoracle2000_at_yahoo.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: Re: HELP - Partitioned option not enabled
>Date: Sat, 11 Nov 2000 11:25:43 -0800
>
>Hi,
>You need to have a enterprise edtion which has a options for partitioned
>option,and it is always available.You have to check what edition you have
>with you .I think v$version might help you in this.for e.g select * from
>v$version will give you the banner.
>Hope this helps you.
>regards,
>Rajanish Joshi
>Pune,India
>
>__________________________________________________
>Do You Yahoo!?
>Yahoo! Calendar - Get organized for the holidays!
>http://calendar.yahoo.com/
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Joshi Rajanish
> INET: dbaoracle2000_at_yahoo.com
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).



Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

Share information about yourself, create your own public profile at Received on Mon Nov 13 2000 - 15:40:36 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US