Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Date column as a partition key question
Don't know what you mean by doesn't work. How about simplifying your
range criteria (see embedded)?
Alex wrote:
> Dear *,
> I have one question, why follozing script does not want to work:
> CREATE TABLE sales (invoice_no NUMBER,
> sale_date DATE NOT NULL,
> sale_id INT NOT NULL)
> PARTITION BY RANGE (
> (to_number (to_char (to_date (sale_date,
> 'YYYYMMDDHH24MISS' ), 'MM' )))
> )
PARTITITON BY RANGE ( to_number( sale_date, 'MM') )> );
> (partition jan VALUES LESS THAN (2),
> partition feb VALUES LESS THAN (3),
> partition mar VALUES LESS THAN (4),
> partition apr VALUES LESS THAN (5),
> partition may VALUES LESS THAN (6),
> partition jun VALUES LESS THAN (7)
> partition jul VALUES LESS THAN (8),
> partition sep VALUES LESS THAN (9),
> partition oct VALUES LESS THAN (10),
> partition nov VALUES LESS THAN (11)