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

테이블 생성 실무사례

 

CREATE UNIQUE INDEXADM.PTORDER

ON ADM.TORDER

(

ORD_NO ASC

)

TABLESPACE TBS_INDEX_OR_4M

PCTFREE 10

INITRANS 8

MAXTRANS 255

STORAGE

(

INITIAL 1048576

NEXT 4194304

MINEXTENTS 1

MAXEXTENTS UNLIMITED

PCTINCREASE 0

BUFFER_POOL DEFAULT

)

LOGGING

NOCOMPRESS

NOPARALLEL;

 

ALTER TABLE ADM. TORDER ADD(

CONSTRAINT PTORDERPRIMARY KEY (ORD_NO));

 

CREATE PUBLIC SYNONYM TORDER FOR ADM.TORDER;