Help: Can't create a partitioned table.
From: sirirut vanichayobon <svanicha_at_cs.ou.edu>
Date: Wed, 10 Mar 1999 17:27:03 -0600
Message-ID: <36E6FFC7.3F3EEFC1_at_cs.ou.edu>
Hello,
26> pctused 90
27> ;
Date: Wed, 10 Mar 1999 17:27:03 -0600
Message-ID: <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 - 00:27:03 CET