Re: Partitioned tables

From: <miroslavn_at_yahoo.com>
Date: Sat, 24 Oct 1998 03:01:02 GMT
Message-ID: <70rfte$n5p$1@nnrp1.dejanews.com>

In article <3624aaa3.0_at_news.webt.com>,
  "bubba" <brittonb_at_webt.com> wrote:
> How do I enable partitioned table creation in oracle 8/NT?
>

You need install additional feches
and

create table billing
partition by range (id) (

partition b_199800 values less than ('199806') tablespace ms ,
partition b_199806 values less than ('199807') tablespace ms ,
partition b_199807 values less than ('199808') tablespace ms ,
partition b_199808 values less than ('199809') tablespace ms ,
partition b_199809 values less than ('199810') tablespace ms ,
partition b_199810 values less than ('199811') tablespace ms )

 as select * from billing_at_old_server;

> I try and create a partitioned table and it says that partitioning is not
> available.
>
> Also, can I take an existing table and partition it?
>
> brittonb_at_webt.com
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Oct 23 1998 - 22:01:02 CDT