Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Date column as a partition key question
If SALE_DATE is a DATE column, then why are you converting this to a
date datatype (TO_DATE)?
Cheers,
Brian
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' )))
> )
> (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)
> );
>
>
> Thanks
> Alex
Received on Wed Nov 13 2002 - 12:45:27 CST