Re: Help: Can't create a partitioned table.

What version of Oracle on what platform are you running on. The support for Partitioned Tables is marginal with 7.x and Ok from about 8.0.4.x.x on.

Mike Rose

sirirut vanichayobon wrote in message <36E6FFC7.3F3EEFC1_at_cs.ou.edu>...
>Hello,
>
> I am trying to create a partitioned table. I got this error message:
>
> ORA-00439: feature not enabled: Partitioning
>
> I don't understand what it means and how to solve it.
>
>Any help and suggestion of this problem?
>
>Thanks in advance,
>-sirirut-
>
>
>PS. The following is my script.
>
> 1> CREATE TABLE MES05A (
> 2> STID VARCHAR2(8) NOT NULL,
> 3> DATE_TIME DATE NOT NULL,
> 4> RELH NUMBER(8,4),
> 5> TAIR NUMBER(8,4),
> 6> WSPD NUMBER(8,4),
> 7> WVEC NUMBER(8,4),
> 8> WDIR NUMBER(8,4),
> 9> WDSD NUMBER(8,4),
> 10> WSSD NUMBER(8,4),
> 11> WMAX NUMBER(8,4),
> 12> RAIN NUMBER(8,4),
> 13> PRES NUMBER(8,4),
> 14> SRAD NUMBER(8,4),
> 15> TA9M NUMBER(8,4),
> 16> WS2M NUMBER(8,4),
> 17> FLSV NUMBER(8,4),
> 18> PRIMARY KEY(STID, DATE_TIME)
> 19> using index tablespace mesindex_1994,
> 20> FOREIGN KEY(STID) REFERENCES
> geotable(STID)
> 21> )
> 22> partition by range (date_time)
> 23> (partition year1994 values less than ('dec-31-94')
> 24> tablespace mes05_1994)
> 25> pctfree 5
> 26> pctused 90
> 27> ;
>
>CREATE TABLE MES05A (
>*
>ORA-00439: feature not enabled: Partitioning
>
>
Received on Thu Mar 11 1999 - 06:16:05 CET