Re: Urgent!!!Partition feature to be enabled

Also note that the partition option is only included in the Enterprise Edition. Check your installation CD and make sure that it has the words "Enterprise Edition" on it.

On Tue, 02 Jan 2001 10:23:07 +0000, Richard J Bragg <richard.bragg.bsc_at_ntl.remove.com> wrote:

>This is a multi-part message in MIME format.
>--------------380EEB2DAF81347D43B1D942
>Content-Type: text/plain; charset=us-ascii
>Content-Transfer-Encoding: 7bit
>
>I had to do this and it is a real pain. You may need to reinstall oracle
>or at least the partitioning option.
>
>Backup data.
>Shutdown Oracle
>Backup files
>Install option
>Restart Oracle.
>
>On one box this worked fine. On another I had to reload the data.
>Also you can't partition a table not created as such.
>
>
>
>Amol wrote:
>
>> To all Oracle Gurus,
>> I have installed oracle 8.0.6 at my place.In the current position
>> I am unable to use "PARTITION BY RANGE" statement to partition the
>> table while creating the same.It gives me an ORA-439 error,which I
>> checked and found that the Partition Feature is not enabled.After going
>> through the V$OPTION the conclusion was the same.
>> Please suggest way to enable this feature.Please this is real
>> urgent.
>> Regards,
>> Amol
>>
>> Sent via Deja.com
>> http://www.deja.com/
>
>--------------380EEB2DAF81347D43B1D942
>Content-Type: text/x-vcard; charset=us-ascii;
> name="richard.bragg.bsc.vcf"
>Content-Transfer-Encoding: 7bit
>Content-Description: Card for Richard J Bragg
>Content-Disposition: attachment;
> filename="richard.bragg.bsc.vcf"
>
>begin:vcard
>n:Bragg;Richard
>tel;work:01483 875182
>x-mozilla-html:FALSE
>url:www.ntl.com
>org:NTL;NMC
>version:2.1
>email;internet:richard.bragg.bsc_at_ntl.remove.com
>title:OSS Development Engineer
>note:Please remove 'bsc' and 'remove' from address to email me.
>adr;quoted-printable:;;Crawley Court=0D=0ACrawley;Winchester;Hampshire;SO21 2QA;UK
>fn:Richard J Bragg
>end:vcard
>
>--------------380EEB2DAF81347D43B1D942--
>
Received on Tue Jan 16 2001 - 19:23:27 CST