CREATE TABLE TABLE_NAME 
   (  ID NUMBER NOT NULL ENABLE, 
   INSDATE TIMESTAMP (6) NOT NULL ENABLE, 
   CONSTRAINT TABLE_NAME_PK PRIMARY KEY (ID)
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 4194304 NEXT 4194304 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE TB1  ENABLE
   ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE TB1 
  PARTITION BY RANGE (INSDATE);
  CREATE UNIQUE INDEX TABLE_NAME_PK ON TABLE_NAME (ID) 

ALTER TABLE TABLE_NAME DROP CONSTRAINT TABLE_NAME_PK;
CREATE UNIQUE INDEX TABLE_NAME_PK ON TABLE_NAME (INSDATE, ID) LOCAL TABLESPACE TB1;
ALTER TABLE TABLE_NAME ADD CONSTRAINT TABLE_NAME_PK PRIMARY KEY (INSDATE, ID);

ALTER TABLE TRUNCATE PARTITION P_NAME UPDATE INDEXES