Re: Partitioned tables

From: MotoX <rat_at_tat.a-tat.com>
Date: Wed, 14 Oct 1998 15:55:13 +0100
Message-ID: <908376810.7258.0.nnrp-11.c2de712e@news.demon.co.uk>

bubba wrote in message <3624aaa3.0_at_news.webt.com>...
>How do I enable partitioned table creation in oracle 8/NT?
>
>I try and create a partitioned table and it says that partitioning is not
>available.

Install the Partitioning Option (it's on the Oracle **Enterprise** CD). You *must pay* for this option, it's not included in the price, even with Enterprise.

>
>Also, can I take an existing table and partition it?

Easiest way is to create the partitioned version from scratch and then copy the rows over (i.e. with SQL or a flat-file dump).

MotoX.

>
>brittonb_at_webt.com
>
>
Received on Wed Oct 14 1998 - 09:55:13 CDT