오라클공부 607. 테이블 생성 실무사례

테이블 생성 실무사례

​

​CREATE TABLE ADM.TORDER
(

 ORD_NO           VARCHAR2 (14) NOT NULL,
 CUST_NO          VARCHAR2 (12),
 CONTACT_NO       NUMBER,
 ORD_DTM          DATE,
 ORD_CLS_CD       VARCHAR2 (3),
 RCPT_ID          VARCHAR2 (10),
 ORD_REF          VARCHAR2 (500),
 PRC_ORD_YN       VARCHAR2 (1),
 INS_ID           VARCHAR2 (10) NOT NULL,
 INS_DTM          DATE NOT NULL,
 MOD_ID           VARCHAR2 (10) NOT NULL,
 MOD_DTM          DATE NOT NULL

)​

TABLESPACE TBS_DATA_OR_4M
PCTFREE 10
PCTUSED 0
INITRANS 4
MAXTRANS 255
STORAGE
(​

 INITIAL 4194304
 NEXT 4194304
 MINEXTENTS 1
 MAXEXTENTS UNLIMITED
 PCTINCREASE 0
 BUFFER_POOL DEFAULT

)
LOGGING ;