CREATE TABLE TB_DEV_GBJJICD ( DEVICE_SEQ NUMBER(8) NOT NULL, LOG_GBJJICD_SEQ NUMBER NOT NULL, LOG_TIME DATE NOT NULL, DEVICE_STATE NUMBER(1), OPERATION_MODE NUMBER(1), MOVE_STAT NUMBER(1), STOP_STAT NUMBER(1), COLLECT_TIME DATE, LOG_DATE VARCHAR2(8 BYTE), EVENT_FLAG NUMBER(1) ) TABLESPACE DATA_SPACE PARTITION BY RANGE (LOG_TIME) ( PARTITION P_2011 VALUES LESS THAN (TO_DATE(' 2012-01-01 00:00:00'..