CREATE TABLE SMDU.SMD_T_ORACLELOG
(
LOGSEQ NUMBER(12,0) NOT NULL,
TENPOCD CHAR(4) NOT NULL,
LOGDATE DATE NOT NULL,
ERRORCD VARCHAR2(12) NOT NULL,
MESSAGE VARCHAR2(1000) NOT NULL,
SYORIFG NUMBER(1,0) NOT NULL,
FILEID CHAR(27) NOT NULL,
UPDATEID CHAR(8) NOT NULL,
UPDATETIME TIMESTAMP(6) NOT NULL,
CONSTRAINT PK_SMD_T_ORACLELOG PRIMARY KEY (LOGSEQ) USING INDEX
PCTFREE 5
INITRANS 2
MAXTRANS 255
TABLESPACE INDX01
STORAGE(INITIAL 16K NEXT 4M MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 BUFFER_POOL DEFAULT)
LOGGING
)
PCTFREE 5
MAXTRANS 255
TABLESPACE DATA01
STORAGE(INITIAL 16K NEXT 8M MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 BUFFER_POOL DEFAULT)
NOCACHE
LOGGING
这是表的定义,现在想指定LOGSEQ为sequence,应该怎么定义!
谢谢大家,在线等!
(
LOGSEQ NUMBER(12,0) NOT NULL,
TENPOCD CHAR(4) NOT NULL,
LOGDATE DATE NOT NULL,
ERRORCD VARCHAR2(12) NOT NULL,
MESSAGE VARCHAR2(1000) NOT NULL,
SYORIFG NUMBER(1,0) NOT NULL,
FILEID CHAR(27) NOT NULL,
UPDATEID CHAR(8) NOT NULL,
UPDATETIME TIMESTAMP(6) NOT NULL,
CONSTRAINT PK_SMD_T_ORACLELOG PRIMARY KEY (LOGSEQ) USING INDEX
PCTFREE 5
INITRANS 2
MAXTRANS 255
TABLESPACE INDX01
STORAGE(INITIAL 16K NEXT 4M MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 BUFFER_POOL DEFAULT)
LOGGING
)
PCTFREE 5
MAXTRANS 255
TABLESPACE DATA01
STORAGE(INITIAL 16K NEXT 8M MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 BUFFER_POOL DEFAULT)
NOCACHE
LOGGING
这是表的定义,现在想指定LOGSEQ为sequence,应该怎么定义!
谢谢大家,在线等!
CREATE SEQUENCE logseq_sequence
START WITH 10000 --默認起始值10000
INCREMENT BY 1; --按1遞增,下一條記錄就是10001