Range partitions - 2 levels deep

From: Raj <nvvrajesh_y_at_yahoo.com>
Date: 7 Nov 2003 08:34:02 -0800
Message-ID: <4932633a.0311070834.60ad1c91@posting.google.com>

I need a table to be partitioned
1. First by range on a number field.
2. By date range.

Anyone attempted this before. I was trying to use "List" for sub-partition. But it doesn't seem to like use of functions anywhere.

This is what i am trying:
CREATE TABLE raj1

(salesman_id NUMBER(5),

sales_date DATE)
PARTITION BY LIST(to_char(sales_date,'MONYYYY'))
( PARTITION sales_jan03 VALUES('JAN2003'),
PARTITION sales_feb03 VALUES ('FEB2003'), PARTITION sales_other VALUES(DEFAULT) );

Has anyone tried this?

Rajesh Received on Fri Nov 07 2003 - 10:34:02 CST