Hi !
I've created this partitioned table. Now, I need to create local index for this. Could someone please post the syntax as to how to do it ?


CREATE TABLE TRACK_COUNT (
ID NUMBER (38) NOT NULL,
TIMESTAMP DATE NOT NULL,
VISITID NUMBER (38) NOT NULL,
HTTPRESOURCEID NUMBER (8) NOT NULL,
LQUERYINFOID NUMBER (38) DEFAULT 0 NOT NULL,
HTTPSTATUSCODE NUMBER (38) NOT NULL,
BYTES NUMBER (38) NOT NULL,
SERVERID NUMBER (38) NOT NULL,
TRANSTIME NUMBER (38),
PARSEID NUMBER (38) NOT NULL )
PARTITION BY RANGE (TIMESTAMP)
( PARTITION P_MAR VALUES LESS THAN (TO_DATE('01042000','DDMMYYYY')) tablespace tbs_track,
PARTITION P_APR VALUES LESS THAN (TO_DATE('01052000','DDMMYYYY')) tablespace tbs_track,
PARTITION P_MAY VALUES LESS THAN (TO_DATE('01062000','DDMMYYYY')) tablespace tbs_track,
PARTITION P_JUN VALUES LESS THAN (TO_DATE('01072000','DDMMYYYY')) tablespace tbs_track,
PARTITION P_JUL VALUES LESS THAN (TO_DATE('01082000','DDMMYYYY')) tablespace tbs_track,
PARTITION P_AUG VALUES LESS THAN (TO_DATE('01092000','DDMMYYYY')) tablespace tbs_track,
PARTITION P_SEP VALUES LESS THAN (TO_DATE('01102000','DDMMYYYY')) tablespace tbs_track2,
PARTITION P_OCT VALUES LESS THAN (TO_DATE('01112000','DDMMYYYY')) tablespace tbs_track2,
PARTITION P_NOV VALUES LESS THAN (TO_DATE('01122000','DDMMYYYY')) tablespace tbs_track2,
PARTITION P_DEC VALUES LESS THAN (TO_DATE('01012001','DDMMYYYY')) tablespace tbs_track2,
PARTITION P_JAN VALUES LESS THAN (TO_DATE('01022001','DDMMYYYY')) tablespace tbs_track2,
PARTITION P_FEB VALUES LESS THAN (TO_DATE('01032001','DDMMYYYY'))
tablespace tbs_track2);


thanks a lot