Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Date column as a partition key question
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 - 11:27:21 CST