Re: How to enable create partioned tables

what is the version of your oracle ??

Patrik Ågren wrote:

> I want to create table with partioning, but when I run the
> statement below I got error ORA-00439: feature not enabled: Partioning.
> I have search in the manual but I can't see how to install it or to
> enable
> the feature. Any suggestion?
>
> CREATE TABLE sales ( acct_no NUMBER(5),
> acct_name
> CHAR(30),
> amount_of_sale NUMBER(6),
> week_no
> INTEGER )
> PARTITION BY RANGE ( week_no )
> (PARTITION sales1 VALUES LESS THAN ( 4 ) TABLESPACE ts0,
> PARTITION sales2 VALUES LESS THAN ( 8 ) TABLESPACE ts1,
> PARTITION sales13 VALUES LESS THAN ( 12 ) TABLESPACE ts3 );
>
> /Patrik
Received on Thu Feb 10 2000 - 04:23:18 CST