Oracle 8 partitioning

From: <kerbiquet_at_hotmail.com>
Date: Thu, 06 Jan 2000 15:09:31 GMT
Message-ID: <852b6u$tb2$1@nnrp1.deja.com>

On Oracle 8.0.6,
is that possible to create a table with a partitioning key on two columns:
1 VARCHAR2 column and 1 DATE column?

If I create
CREATE TABLE sales
(NAME VARCHAR2(10),
DAY DATE,
TEXT VARCHAR2(40))
PARTITION BY RANGE(NAME,MONTH)

PARTITION JOHN_JAN VALUES LESS THAN ('JOHN',TO_DATE('2000-01','YYYY-MM')
PARTITION JOHN_FEB VALUES LESS THAN ('JOHN',TO_DATE('2000-02','YYYY-MM')
PARTITION JACK_JAN VALUES LESS THAN ('JACK',TO_DATE('2000-01','YYYY-MM')

In which partition goes VALUES('JOHN',TO_DATE('2000-02','YYYY-MM')?

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Jan 06 2000 - 09:09:31 CST