Re: Partitioning table on Oracle 8

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Thu, 06 Jan 2000 19:52:30 +0800
Message-ID: <387481FE.7E2D@yahoo.com>

kerbiquet_at_hotmail.com wrote:
>
> 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.

Check the partitioning explanation in the concepts guide...It explains in detail about how oracle decides on which partition to allocate multi-key partitions

HTH
--

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Thu Jan 06 2000 - 05:52:30 CST