Table Partition

[rajanbabu23]

dear friends,

If i insert a row into table SALES ...If created_dt , Jan or Feb or Mar ...it will store separate partition...I tried the below script ..it's was not working.,

Script :

CREATE TABLE sales
( prod_id NUMBER(6),
create_dt DATE
)
PARTITION BY LIST (to_char(create _dt,'MON'))
(PARTITION SALES_JAN VALUES ('JAN'),
PARTITION SALES_FEB VALUES ('FEB'),
PARTITION SALES_MAR VALUES ('MAR'),
PARTITION REST VALUES (DEFAULT))

[debasisdas]

Since you have posted a question in the article section it is being moved to oracle forum


MODERATOR.