Re: Date column as a partition key question

1. Need to know the exact error message you get when you try to run this script
2. Need to know datatype of sale_date column (you cannot use to_date function on a date column)
3. I noticed you are missing a comma after (7)

Martin

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 - 13:54:10 CST