Create Table
Oracle® Database SQL Language Reference
11g Release 1 (11.1)
Part Number B28286-05
http://download.oracle.com/docs/cd/B28359_01/server.111/b28286/statements_7002.htm
CREATE TABLE USER.TABLE_NAME
(
RECORD_KEY NUMBER NOT NULL,
JOB_NO NUMBER NOT NULL,
USERNAME VARCHAR2(300 BYTE),
USER_ACTION VARCHAR2(100 BYTE),
ACTION_DATE DATE
)
TABLESPACE USER_TBL
PCTUSED 0
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 1M
NEXT 1M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
)
LOGGING
NOCACHE
NOPARALLEL;
0 comments:
Post a Comment