表结构
CREATE TABLE T_CH_REC
(
ID VARCHAR2(22) NOT NULL,
NAME VARCHAR2(30) NOT NULL,
SEX VARCHAR2(1) NOT NULL,
NATION VARCHAR2(2) NOT NULL,
BDATE VARCHAR2(8),
ID_NAME VARCHAR2(2) NOT NULL,
ID_CODE VARCHAR2(18) NOT NULL,
XZQH VARCHAR2(6),
ADDRESS VARCHAR2(60),
IN_TIME VARCHAR2(12),
NO_ROOM VARCHAR2(10),
OUT_TIME VARCHAR2(12),
TRA_TIME VARCHAR2(12),
CREDIT_CODE VARCHAR2(10),
CREDIT_NO VARCHAR2(19),
STA_CODE VARCHAR2(9),
BUR_CODE VARCHAR2(6),
SPM VARCHAR2(30),
INSERT_TIME VARCHAR2(20),
MEMO VARCHAR2(200),
XUHAO NUMBER(10,0),
HOTELID VARCHAR2(10),
PDAFLAG VARCHAR2(4),
DRAGOMANAME VARCHAR2(50),
DRAGOMAPHONE VARCHAR2(50),
GROUPNO VARCHAR2(50),
CONSTRAINT T_CH_REC_ID UNIQUE (ID) USING INDEX
)
PCTFREE 10
MAXTRANS 255
TABLESPACE DATA
STORAGE(INITIAL 0M MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT)
NOCACHE
NOLOGGING
/
CREATE UNIQUE INDEX IDX_CH_RECID
ON T_CH_REC
(ID)
PCTFREE 10
INITRANS 2
MAXTRANS 255
TABLESPACE DATA
STORAGE(INITIAL 1008824K MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT)
NOLOGGING
/
CREATE INDEX IDX_CH_RECIN_TIME
ON T_CH_REC
(IN_TIME)
PCTFREE 10
INITRANS 2
MAXTRANS 255
TABLESPACE DATA
STORAGE(INITIAL 672488K MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT)
NOLOGGING
/
CREATE INDEX IDX_CH_RECOUT_TIME
ON T_CH_REC
(OUT_TIME)
PCTFREE 10
INITRANS 2
MAXTRANS 255
TABLESPACE DATA
STORAGE(INITIAL 672504K MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT)
NOLOGGING
/
CREATE INDEX IDX_CH_RECSFZH
ON T_CH_REC
(ID_CODE)
PCTFREE 10
INITRANS 2
MAXTRANS 255
TABLESPACE DATA
STORAGE(INITIAL 672504K MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT)
NOLOGGING
/
CREATE INDEX IDX_CH_REC_BDATE
ON T_CH_REC
(BDATE)
PCTFREE 10
INITRANS 2
MAXTRANS 255
TABLESPACE DATA
STORAGE(INITIAL 478320K MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT)
LOGGING
/
CREATE INDEX IDX_CH_REC_NAME
ON T_CH_REC
(NAME)
PCTFREE 10
INITRANS 2
MAXTRANS 255
TABLESPACE DATA
STORAGE(INITIAL 478320K MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT)
LOGGING
/
建表时出现问题
急死了
CREATE TABLE T_CH_REC
(
ID VARCHAR2(22) NOT NULL,
NAME VARCHAR2(30) NOT NULL,
SEX VARCHAR2(1) NOT NULL,
NATION VARCHAR2(2) NOT NULL,
BDATE VARCHAR2(8),
ID_NAME VARCHAR2(2) NOT NULL,
ID_CODE VARCHAR2(18) NOT NULL,
XZQH VARCHAR2(6),
ADDRESS VARCHAR2(60),
IN_TIME VARCHAR2(12),
NO_ROOM VARCHAR2(10),
OUT_TIME VARCHAR2(12),
TRA_TIME VARCHAR2(12),
CREDIT_CODE VARCHAR2(10),
CREDIT_NO VARCHAR2(19),
STA_CODE VARCHAR2(9),
BUR_CODE VARCHAR2(6),
SPM VARCHAR2(30),
INSERT_TIME VARCHAR2(20),
MEMO VARCHAR2(200),
XUHAO NUMBER(10,0),
HOTELID VARCHAR2(10),
PDAFLAG VARCHAR2(4),
DRAGOMANAME VARCHAR2(50),
DRAGOMAPHONE VARCHAR2(50),
GROUPNO VARCHAR2(50),
CONSTRAINT T_CH_REC_ID UNIQUE (ID) USING INDEX
)
PCTFREE 10
MAXTRANS 255
TABLESPACE DATA
STORAGE(INITIAL 0M MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT)
NOCACHE
NOLOGGING
/
CREATE UNIQUE INDEX IDX_CH_RECID
ON T_CH_REC
(ID)
PCTFREE 10
INITRANS 2
MAXTRANS 255
TABLESPACE DATA
STORAGE(INITIAL 1008824K MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT)
NOLOGGING
/
CREATE INDEX IDX_CH_RECIN_TIME
ON T_CH_REC
(IN_TIME)
PCTFREE 10
INITRANS 2
MAXTRANS 255
TABLESPACE DATA
STORAGE(INITIAL 672488K MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT)
NOLOGGING
/
CREATE INDEX IDX_CH_RECOUT_TIME
ON T_CH_REC
(OUT_TIME)
PCTFREE 10
INITRANS 2
MAXTRANS 255
TABLESPACE DATA
STORAGE(INITIAL 672504K MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT)
NOLOGGING
/
CREATE INDEX IDX_CH_RECSFZH
ON T_CH_REC
(ID_CODE)
PCTFREE 10
INITRANS 2
MAXTRANS 255
TABLESPACE DATA
STORAGE(INITIAL 672504K MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT)
NOLOGGING
/
CREATE INDEX IDX_CH_REC_BDATE
ON T_CH_REC
(BDATE)
PCTFREE 10
INITRANS 2
MAXTRANS 255
TABLESPACE DATA
STORAGE(INITIAL 478320K MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT)
LOGGING
/
CREATE INDEX IDX_CH_REC_NAME
ON T_CH_REC
(NAME)
PCTFREE 10
INITRANS 2
MAXTRANS 255
TABLESPACE DATA
STORAGE(INITIAL 478320K MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT)
LOGGING
/
建表时出现问题
急死了
出现这样的问题