Oracle - 파티션 추가 쿼리

ALTER TABLE TB_IEM124 ADD PARTITION TB_IEM124_P1_L_200712
VALUES ('0L0712') TABLESPACE IEPCS_TABLE
PCTFREE 20 INITRANS 1 MAXTRANS 255
STORAGE
(
INITIAL 1M
MINEXTENTS 1
MAXEXTENTS UNLIMITED
)
;

ALTER TABLE TB_IEM124 ADD PARTITION TB_IEM124_P1_C_200712
VALUES ('0C0712') TABLESPACE IEPCS_TABLE
PCTFREE 20 INITRANS 1 MAXTRANS 255
STORAGE
(
INITIAL 1M
MINEXTENTS 1
MAXEXTENTS UNLIMITED
)
;

댓글 없음:

댓글 쓰기