Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: HELP - Partitioned option not enabled
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).
Share information about yourself, create your own public profile at Received on Mon Nov 13 2000 - 15:40:36 CST