[오라클] 파티셔닝 샘플

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', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
                NOLOGGING
                NOCOMPRESS
                TABLESPACE HITMS_DATA
                PCTFREE    10
                INITRANS   2
                MAXTRANS   255
                STORAGE    (
                            INITIAL          64K
                            NEXT             1M
                            MINEXTENTS       1
                            MAXEXTENTS       UNLIMITED
                            BUFFER_POOL      DEFAULT
                           ), 
              PARTITION P_201201 VALUES LESS THAN (MAXVALUE)
                NOLOGGING
                NOCOMPRESS
                TABLESPACE HITMS_DATA
                PCTFREE    10
                INITRANS   2
                MAXTRANS   255
                STORAGE    (
                            INITIAL          64K
                            NEXT             1M
                            MINEXTENTS       1
                            MAXEXTENTS       UNLIMITED
                            BUFFER_POOL      DEFAULT
                           )                          
            );