partition table range on date

From: Nancy Teh <Nancy.Teh_at_cc.monash.edu.au>
Date: Thu, 07 May 1998 16:32:41 +1100
Message-ID: <35515589.E848F5BE@cc.monash.edu.au>

Hi,

Can someone tell me where I have done wrong? I am trying to create a table partition, the script as follows:

create table NANCY.LOG
(

LOG_DTE DATE NOT NULL,
INS_DTE DATE NOT NULL,
SRC VARCHAR2(1) NOT NULL,
BYT_CNT NUMBER NOT NULL
)
partition by range(LOG_DTE)
(partition year96 values less than ('01-Jan-97')
 tablespace TS_96,
 partition year97 values less than ('01-Jan-98')  tablespace TS_97,
 partition year98 values less than ('01-Jan-99')  tablespace TS_98
);

I keep getting this error message
ORA-14120: incompletely specified partition bound for a DATE column

Second question, if the 98 partition get filled up; that is run out of tablespace TS_98. Can I resize the partition like the way I resize a datafile.

Send me an email if you can. Thank in advance.

---

Nancy Teh
Email:Nancy.Teh_at_cc.monash.edu.au

---

Received on Thu May 07 1998 - 00:32:41 CDT