db1@root[/>]uptime
01:13PM up 16:18, 2 users, load average: 0.19, 0.28, 0.27
db1@root[/>]date
Tue Mar 17 13:13:53 BEIST 2009
db1@root[/>]mklv -t raw -y tdxtdata01 -U oracle -G dba datavg 32 hdisk2
tdxtdata01
db1@root[/>]mklv -t raw -y tdxtdata02 -U oracle -G dba datavg 32 hdisk2
tdxtdata02
db1@root[/>]mklv -t raw -y tdxtbig01 -U oracle -G dba datavg 32 hdisk2
tdxtbig01
db1@root[/>]mklv -t raw -y tdxtbig02 -U oracle -G dba datavg 32 hdisk2
tdxtbig02
db1@root[/>]mklv -t raw -y tdxtbig03 -U oracle -G dba datavg 32 hdisk2
tdxtbig03
db1@root[/>]mklv -t raw -y tdxtbig04 -U oracle -G dba datavg 32 hdisk2
tdxtbig04
db1@root[/>]mklv -t raw -y tdxtidx01 -U oracle -G dba datavg 32 hdisk2
tdxtidx01
db1@root[/>]mklv -t raw -y tdxtidx02 -U oracle -G dba datavg 32 hdisk2
tdxtidx02
db1@root[/>]mklv -t raw -y tdxtbigidx01 -U oracle -G dba datavg 32 hdisk2
tdxtbigidx01
db1@root[/>]mklv -t raw -y tdxtbigidx02 -U oracle -G dba datavg 32 hdisk2
tdxtbigidx02
db1@root[/>]mklv -t raw -y tdxtbigidx03 -U oracle -G dba datavg 32 hdisk2
tdxtbigidx03
db1@root[/>]mklv -t raw -y tdxtbigidx04 -U oracle -G dba datavg 32 hdisk2
tdxtbigidx04
db1@root[/>]date
Tue Mar 17 13:15:46 BEIST 2009
db1@root[/>]lsvg datavg
VOLUME GROUP: datavg VG IDENTIFIER: 00c4bd5e00004c000000010317753845
VG STATE: active PP SIZE: 64 megabyte(s)
VG PERMISSION: read/write TOTAL PPs: 4079 (261056 megabytes)
MAX LVs: 256 FREE PPs: 1048 (67072 megabytes)
LVs: 119 USED PPs: 3031 (193984 megabytes)
OPEN LVs: 101 QUORUM: 1
TOTAL PVs: 1 VG DESCRIPTORS: 2
STALE PVs: 0 STALE PPs: 0
ACTIVE PVs: 1 AUTO ON: no
MAX PPs per PV: 5080 MAX PVs: 6
LTG size: 128 kilobyte(s) AUTO SYNC: no
HOT SPARE: no BB POLICY: relocatable
SQL> select to_char(sysdate,'YYYYMMDD') "Datedb",
2 d.tablespace_name Tablespace, d.ds Totalsize,
3 d.ds-f.fs usedsize, f.fs freesize,(d.ds-f.fs)*100/d.ds used_pct
4 from (select tablespace_name,sum(bytes/1024/1024) ds
5 from dba_data_files
6 group by tablespace_name) d,
7 (select tablespace_name,sum(bytes/1024/1024) fs
8 from dba_free_space
9 group by tablespace_name) f
10 where d.tablespace_name=f.tablespace_name;
Datedb TABLESPACE TOTALSIZE USEDSIZE FREESIZE USED_PCT
-------- ------------------------------ ---------- ---------- ---------- ----------
20090317 PERFSTAT 500 188.8125 311.1875 37.7625
20090317 SYSTEM 511 208.375 302.625 40.7778864
20090317 TJFXBIGDATA 5109 3182 1927 62.2822470
20090317 TJFXBIGIDX 10219 6729.5 3489.5 65.8528231
20090317 TJFXDATA 1023 0.546875 1022.45312 0.05345796
20090317 TJFXIDX 511 0.921875 510.078125 0.18040606
20090317 TOOLS 255 0.0625 254.9375 0.02450980
20090317 UNDO1 2558 296.6875 2261.3125 11.5984167
20090317 USERS 255 0.0625 254.9375 0.02450980
20090317 YZZJBIGDATA 20462 13750 6712 67.1977323
20090317 YZZJBIGIDX 22508 16660 5848 74.0181268
20090317 YZZJDATA 22502 16676.9687 5825.03125 74.1132732
20090317 YZZJIDX 3069 318.734375 2750.26562 10.3856101
20090317 ZJDADATA 71638 47593 24045 66.4354113
14 rows selected
SQL> CREATE TABLESPACE TDXTDATA DATAFILE '/dev/rtdxtdata01' size 2047M autoextend off;
Tablespace created
SQL> alter tablespace TDXTDATA add datafile '/dev/rtdxtdata02' size 2047M autoextend off;
Tablespace altered
SQL> CREATE TABLESPACE TDXTBIGDATA DATAFILE '/dev/rtdxtbig01' size 2047M autoextend off;
Tablespace created
SQL> alter tablespace TDXTBIGDATA add datafile '/dev/rtdxtbig02' size 2047M autoextend off;
Tablespace altered
SQL> alter tablespace TDXTBIGDATA add datafile '/dev/rtdxtbig03' size 2047M autoextend off;
Tablespace altered
SQL> alter tablespace TDXTBIGDATA add datafile '/dev/rtdxtbig04' size 2047M autoextend off;
Tablespace altered
SQL> CREATE TABLESPACE TDXTIDX DATAFILE '/dev/rtdxtidx01' size 2047M autoextend off;
Tablespace created
SQL> alter tablespace TDXTIDX add datafile '/dev/rtdxtidx02' size 2047M autoextend off;
Tablespace altered
SQL> CREATE TABLESPACE TDXTBIGIDX DATAFILE '/dev/rtdxtbigidx01' size 2047M autoextend off;
Tablespace created
SQL> alter tablespace TDXTBIGIDX add datafile '/dev/rtdxtbigidx02' size 2047M autoextend off;
Tablespace altered
SQL> alter tablespace TDXTBIGIDX add datafile '/dev/rtdxtbigidx03' size 2047M autoextend off;
Tablespace altered
SQL> alter tablespace TDXTBIGIDX add datafile '/dev/rtdxtbigidx04' size 2047M autoextend off;
Tablespace altered
SQL>
Datedb TABLESPACE TOTALSIZE USEDSIZE FREESIZE USED_PCT
-------- ------------------------------ ---------- ---------- ---------- ----------
20090317 PERFSTAT 500 188.8125 311.1875 37.7625
20090317 SYSTEM 511 208.375 302.625 40.7778864
20090317 TDXTBIGDATA 8188 0.25 8187.75 0.00305324
20090317 TDXTBIGIDX 8188 0.25 8187.75 0.00305324
20090317 TDXTDATA 4094 0.125 4093.875 0.00305324
20090317 TDXTIDX 4094 0.125 4093.875 0.00305324
20090317 TJFXBIGDATA 5109 3182 1927 62.2822470
20090317 TJFXBIGIDX 10219 6729.5 3489.5 65.8528231
20090317 TJFXDATA 1023 0.546875 1022.45312 0.05345796
20090317 TJFXIDX 511 0.921875 510.078125 0.18040606
20090317 TOOLS 255 0.0625 254.9375 0.02450980
20090317 UNDO1 2558 295.75 2262.25 11.5617670
20090317 USERS 255 0.0625 254.9375 0.02450980
20090317 YZZJBIGDATA 20462 13750 6712 67.1977323
20090317 YZZJBIGIDX 22508 16660 5848 74.0181268
20090317 YZZJDATA 22502 16677.0312 5824.96875 74.1135510
20090317 YZZJIDX 3069 318.734375 2750.26562 10.3856101
20090317 ZJDADATA 71638 47593 24045 66.4354113
18 rows selected
SQL> CREATE USER TDXT IDENTIFIED BY TDXT DEFAULT TABLESPACE TDXTDATA TEMPORARY TABLESPACE TEMP;
User created
SQL> GRANT CONNECT,CREATE PROCEDURE,CREATE TRIGGER TO TDXT;
Grant succeeded
SQL> ALTER USER TDXT QUOTA UNLIMITED ON TDXTDATA;
User altered
SQL> ALTER USER TDXT QUOTA UNLIMITED ON TDXTIDX;
User altered
SQL> ALTER USER TDXT QUOTA UNLIMITED ON TDXTBIGDATA;
User altered
SQL> ALTER USER TDXT QUOTA UNLIMITED ON TDXTBIGIDX;
User altered
SQL> GRANT SELECT ON ZHW_T_JDXXB TO TDXT;
Grant succeeded
SQL> GRANT SELECT ON ZHW_T_DZXXB TO TDXT;
Grant succeeded
SQL> GRANT SELECT ON ZHW_T_DWXXB TO TDXT;
Grant succeeded
SQL>
SQL> GRANT SELECT ON ZHW_T_TDDDB TO TDXT;
Grant succeeded
SQL> GRANT SELECT ON ZHW_T_TDFA TO TDXT;
Grant succeeded
SQL> GRANT SELECT ON ZHW_T_XZQH TO TDXT;
Grant succeeded
SQL> GRANT SELECT ON ZHW_T_ZJQHYB TO TDXT;
Grant succeeded
SQL> GRANT SELECT ON ZHW_T_ZJXZQH TO TDXT;
Grant succeeded
SQL> GRANT SELECT ON ZJCT_T_CTYJ TO TDXT;
Grant succeeded
SQL> GRANT SELECT ON ZJCT_T_JSB TO TDXT;
Grant succeeded
SQL> GRANT SELECT ON TD_T_JKBKDJ TO TDXT;
Grant succeeded
SQL> GRANT SELECT ON TD_T_YQDJB TO TDXT;
Grant succeeded
SQL> GRANT SELECT ON TD_T_DQDH TO TDXT;
Grant succeeded
SQL> GRANT SELECT ON DX_T_BKML TO TDXT;
Grant succeeded
SQL> GRANT SELECT ON ZHW_T_ZJDWXX TO TDXT;
Grant succeeded
SQL> GRANT SELECT ON ZHW_T_ZJDYXX TO TDXT;
Grant succeeded
SQL> GRANT SELECT ON ZHW_T_ZJDZXX TO TDXT;
Grant succeeded
SQL>
SQL> GRANT ALL ON ZHW_T_JGB TO TDXT;
Grant succeeded
SQL> GRANT ALL ON ZHW_T_YGB TO TDXT;
Grant succeeded
SQL> GRANT ALL ON ZHW_T_YGJS TO TDXT;
Grant succeeded
SQL> GRANT ALL ON ZHW_T_TXB TO TDXT;
Grant succeeded
SQL> GRANT ALL ON ZHW_T_GWB TO TDXT;
Grant succeeded
SQL> GRANT ALL ON ZHW_T_GWQX TO TDXT;
Grant succeeded
SQL> GRANT ALL ON ZHW_T_JSGWQX TO TDXT;
Grant succeeded
SQL> GRANT ALL ON ZHW_T_XTQX TO TDXT;
Grant succeeded
SQL> GRANT ALL ON ZHW_T_MMB TO TDXT;
Grant succeeded
SQL> GRANT ALL ON ZHW_T_GNMK TO TDXT;
Grant succeeded
SQL> GRANT ALL ON ZHW_T_XTB TO TDXT;
Grant succeeded
SQL> GRANT ALL ON ZHW_T_TDJMB TO TDXT;
Grant succeeded
SQL> GRANT ALL ON ZHW_T_JGJB TO TDXT;
Grant succeeded
SQL> GRANT ALL ON ZHW_T_GJDM TO TDXT;
Grant succeeded
SQL> GRANT ALL ON ZHW_T_GNDM TO TDXT;
Grant succeeded
SQL>
created Synonym
SQL> CREATE OR REPLACE SYNONYM ZHW_T_JDXXB FOR YZZJ.ZHW_T_JDXXB;
Synonym created
SQL> CREATE OR REPLACE SYNONYM ZHW_T_DZXXB FOR YZZJ.ZHW_T_DZXXB;
Synonym created
SQL> CREATE OR REPLACE SYNONYM ZHW_T_DWXXB FOR YZZJ.ZHW_T_DWXXB;
Synonym created
SQL> CREATE OR REPLACE SYNONYM ZHW_T_XZQH FOR YZZJ.ZHW_T_XZQH;
Synonym created
SQL> CREATE OR REPLACE SYNONYM ZHW_T_ZJQHYB FOR YZZJ.ZHW_T_ZJQHYB;
Synonym created
SQL> CREATE OR REPLACE SYNONYM ZHW_T_ZJXZQH FOR YZZJ.ZHW_T_ZJXZQH;
Synonym created
SQL> CREATE OR REPLACE SYNONYM ZHW_T_TDFA FOR YZZJ.ZHW_T_TDFA;
Synonym created
SQL> CREATE OR REPLACE SYNONYM ZHW_T_TDDDB FOR YZZJ.ZHW_T_TDDDB;
Synonym created
SQL> CREATE OR REPLACE SYNONYM ZJCT_T_CTYJ FOR YZZJ.ZJCT_T_CTYJ;
Synonym created
SQL> CREATE OR REPLACE SYNONYM ZJCT_T_JSB FOR YZZJ.ZJCT_T_JSB;
Synonym created
SQL> CREATE OR REPLACE SYNONYM TD_T_JKBKDJ FOR YZZJ.TD_T_JKBKDJ;
Synonym created
SQL> CREATE OR REPLACE SYNONYM TD_T_YQDJB FOR YZZJ.TD_T_YQDJB;
Synonym created
SQL> CREATE OR REPLACE SYNONYM TD_T_DQDH FOR YZZJ.TD_T_DQDH;
Synonym created
SQL> CREATE OR REPLACE SYNONYM DX_T_BKML FOR YZZJ.DX_T_BKML;
Synonym created
SQL> CREATE OR REPLACE SYNONYM ZHW_T_JGB FOR ZHW.ZHW_T_JGB;
Synonym created
SQL> CREATE OR REPLACE SYNONYM ZHW_T_TXB FOR ZHW.ZHW_T_TXB;
Synonym created
SQL> CREATE OR REPLACE SYNONYM ZHW_T_GWB FOR ZHW.ZHW_T_GWB;
Synonym created
SQL> CREATE OR REPLACE SYNONYM ZHW_T_YGB FOR ZHW.ZHW_T_YGB;
Synonym created
SQL> CREATE OR REPLACE SYNONYM ZHW_T_YGJS FOR ZHW.ZHW_T_YGJS;
Synonym created
SQL> CREATE OR REPLACE SYNONYM ZHW_T_JSGWQX FOR ZHW.ZHW_T_JSGWQX;
Synonym created
SQL> CREATE OR REPLACE SYNONYM ZHW_T_XTQX FOR ZHW.ZHW_T_XTQX;
Synonym created
SQL> CREATE OR REPLACE SYNONYM ZHW_T_GWQX FOR ZHW.ZHW_T_GWQX;
Synonym created
SQL> CREATE OR REPLACE SYNONYM ZHW_T_GNMK FOR ZHW.ZHW_T_GNMK;
Synonym created
SQL> CREATE OR REPLACE SYNONYM ZHW_T_XTB FOR ZHW.ZHW_T_XTB;
Synonym created
SQL> CREATE OR REPLACE SYNONYM ZHW_T_MMB FOR ZHW.ZHW_T_MMB;
Synonym created
SQL> CREATE OR REPLACE SYNONYM ZHW_T_GJDM FOR ZHW.ZHW_T_GJDM;
Synonym created
SQL> CREATE OR REPLACE SYNONYM ZHW_T_GNDM FOR ZHW.ZHW_T_GNDM;
Synonym created
SQL>
SQL> CREATE OR REPLACE SYNONYM ZHW_S_JGJB FOR ZHW.ZHW_T_JGJB;
Synonym created
SQL> CREATE OR REPLACE SYNONYM ZHW_S_TDJMB FOR ZHW.ZHW_T_TDJMB;
Synonym created
SQL> CREATE OR REPLACE SYNONYM ZHW_T_DYXXB FOR YZZJ.ZHW_T_DYXXB;
Synonym created
SQL> CREATE OR REPLACE SYNONYM ZHW_T_ZJDYXX FOR YZZJ.ZHW_T_ZJDYXX;
Synonym created
SQL> CREATE OR REPLACE SYNONYM ZHW_T_ZJDWXX FOR YZZJ.ZHW_T_ZJDWXX;
Synonym created
SQL> CREATE OR REPLACE SYNONYM ZHW_T_ZJDZXX FOR YZZJ.ZHW_T_ZJDZXX;
Synonym created
tdxt:create table
SQL> CREATE TABLE SEQUENCE (
2 NAME VARCHAR2(100) NOT NULL,
3 NEXTID NUMBER(38) NOT NULL,
4 TABLE_NAME VARCHAR2(100) NOT NULL,
5 COLUMN_NAME VARCHAR2(100) NOT NULL
6 );
Table created
SQL> ALTER TABLE SEQUENCE
2 ADD PRIMARY KEY (NAME)
3 USING INDEX
4 TABLESPACE TDXTIDX;
Table altered
SQL> CREATE TABLE SYS_DEPT (
2 SYS_DEPT_ID NUMBER(38) NOT NULL,
3 DEPT_NAME VARCHAR2(100) NOT NULL,
4 DEPT_FATHER_ID NUMBER(38) NOT NULL,
5 DEPT_ORDER NUMBER(38) NULL,
6 REMARK VARCHAR2(250) NULL,
7 FLAG NUMBER(38) NULL
8 );
Table created
SQL> ALTER TABLE SYS_DEPT
2 ADD PRIMARY KEY (SYS_DEPT_ID)
3 USING INDEX
4 TABLESPACE TDXTIDX;
Table altered
SQL> CREATE TABLE SYS_FLAT (
2 SYS_FLAT_CODE VARCHAR2(100) NOT NULL,
3 SYS_FLAT_NAME VARCHAR2(200) NOT NULL,
4 FATHER_CODE VARCHAR2(100) NOT NULL,
5 SYS_FLAT_REMARK VARCHAR2(250) NULL,
6 FLAG NUMBER(38) NOT NULL,
7 USER_ID_SESSION VARCHAR2(100) NULL,
8 USER_ROLE_SESSION VARCHAR2(100) NULL
9 );
Table created
SQL> ALTER TABLE SYS_FLAT
2 ADD PRIMARY KEY (SYS_FLAT_CODE)
3 USING INDEX
4 TABLESPACE TDXTIDX;
Table altered
SQL> CREATE TABLE SYS_FUNCTION (
2 FUNCTION_ID VARCHAR2(60) NOT NULL,
3 MENU_ID VARCHAR2(50) NULL,
4 FUNCTION_NAME VARCHAR2(100) NOT NULL,
5 FUNCTION_CODE VARCHAR2(100) NOT NULL,
6 FUNCTION_REMARK VARCHAR2(250) NULL,
7 FLAG NUMBER(38) NOT NULL
8 );
Table created
SQL> ALTER TABLE SYS_FUNCTION
2 ADD PRIMARY KEY (FUNCTION_ID)
3 USING INDEX
4 TABLESPACE TDXTIDX;
Table altered
SQL> CREATE TABLE SYS_LOG (
2 SYS_LOG_ID NUMBER(38) NOT NULL,
3 USER_ID NUMBER(38) NOT NULL,
4 IP VARCHAR2(16) NOT NULL,
5 MENU_ID VARCHAR2(50) NULL,
6 FUNCTION_CODE VARCHAR2(255) NULL,
7 CONTENT VARCHAR2(4000) NULL,
8 TIMES DATE NULL
9 );
Table created
SQL> ALTER TABLE SYS_LOG
2 ADD PRIMARY KEY (SYS_LOG_ID)
3 USING INDEX
4 TABLESPACE TDXTIDX;
Table altered
SQL> CREATE TABLE SYS_MENU (
2 MENU_ID VARCHAR2(50) NOT NULL,
3 SYS_FLAT_CODE VARCHAR2(100) NOT NULL,
4 MENU_NAME VARCHAR2(100) NOT NULL,
5 MENU_FATHER_ID VARCHAR2(50) NULL,
6 MENU_ORDER NUMBER(38) NULL,
7 MENU_URL VARCHAR2(250) NULL,
8 MENU_ICON VARCHAR2(250) NULL,
9 MENU_REMARK VARCHAR2(250) NULL,
10 MENU_TYPE NUMBER(38) NULL,
11 IF_SHOW NUMBER(38) NULL,
12 FLAG NUMBER(38) NULL
13 );
Table created
SQL> ALTER TABLE SYS_MENU
2 ADD PRIMARY KEY (MENU_ID)
3 USING INDEX
4 TABLESPACE TDXTIDX;
Table altered
SQL> CREATE TABLE SYS_PARAMETER (
2 PARAMETER_ID NUMBER(38) NOT NULL,
3 PARAMETER_TYPE VARCHAR2(50) NOT NULL,
4 PARAMETER_VALUE VARCHAR2(2000) NULL,
5 PARAMETER_NAME VARCHAR2(100) NULL,
6 FLAG NUMBER(38) NOT NULL,
7 SYS_FLAT_CODE VARCHAR2(100) NULL
8 );
Table created
SQL> ALTER TABLE SYS_PARAMETER
2 ADD PRIMARY KEY (PARAMETER_ID)
3 USING INDEX
4 TABLESPACE TDXTIDX;
Table altered
SQL> CREATE TABLE SYS_PARAMETER_TYPE (
2 SYS_PARAMETER_TYPE_ID NUMBER(38) NOT NULL,
3 PARAMETER_TYPE VARCHAR2(50) NOT NULL,
4 FATHER_ID NUMBER(38) NOT NULL,
5 SYS_FLAT_CODE VARCHAR2(100) NOT NULL,
6 PARAMETER_TYPE_NAME VARCHAR2(100) NOT NULL,
7 VALUE_TYPE NUMBER(38) NULL,
8 FIELD_TYPE NUMBER(38) NULL,
9 VIEW_ORDER NUMBER(38) NULL,
10 FLAG NUMBER(38) NULL
11 );
Table created
SQL> ALTER TABLE SYS_PARAMETER_TYPE
2 ADD PRIMARY KEY (SYS_PARAMETER_TYPE_ID, PARAMETER_TYPE)
3 USING INDEX
4 TABLESPACE TDXTIDX;
Table altered
SQL> CREATE TABLE SYS_ROLE (
2 ROLE_ID NUMBER(38) NOT NULL,
3 SYS_FLAT_CODE VARCHAR2(100) NOT NULL,
4 ROLE_NAME VARCHAR2(100) NOT NULL,
5 ROLE_REMARK VARCHAR2(100) NULL,
6 FLAG NUMBER(38) NULL
7 );
Table created
SQL> ALTER TABLE SYS_ROLE
2 ADD PRIMARY KEY (ROLE_ID)
3 USING INDEX
4 TABLESPACE TDXTIDX;
Table altered
SQL> CREATE TABLE SYS_ROLE_POPEDOM (
2 ROLE_ID NUMBER(38) NOT NULL,
3 FUNCTION_ID VARCHAR2(60) NOT NULL,
4 ROLE_POPEDOM_REMARK VARCHAR2(250)
5 );
Table created
SQL> CREATE TABLE SYS_USER (
2 SYS_USER_ID NUMBER(38) NOT NULL,
3 SYS_DEPT_ID NUMBER(38) NULL,
4 USER_NO VARCHAR2(100) NULL,
5 USER_PSWD VARCHAR2(250) NOT NULL,
6 USER_EMAIL VARCHAR2(255) NULL,
7 USER_NAME VARCHAR2(100) NOT NULL,
8 USER_AGE NUMBER(38) NULL,
9 USER_SEX NUMBER(38) NOT NULL,
10 FLAG NUMBER(38) NOT NULL,
11 REG_DATE DATE NULL,
12 V_JGMC VARCHAR2(16) NULL,
13 C_JGBH CHAR(8) NULL,
14 DEPT_NAME VARCHAR2(100) NULL
15 );
Table created
SQL> ALTER TABLE SYS_USER
2 ADD PRIMARY KEY (SYS_USER_ID)
3 USING INDEX
4 TABLESPACE TDXTIDX;
Table altered
SQL> CREATE TABLE SYS_USER_ROLE (
2 SYS_FLAT_CODE VARCHAR2(100) NOT NULL,
3 USER_ID NUMBER(38) NOT NULL,
4 ROLE_ID NUMBER(38) NOT NULL
5 );
Table created
SQL> CREATE TABLE TB_JMS_DADATB (
2 INTER_NAME VARCHAR2(20) NOT NULL,
3 PROV_CD CHAR(2) NOT NULL,
4 CUSTOMER_TARGET VARCHAR2(20) NOT NULL,
5 RECVSEND_IND CHAR(1) NULL
6 );
Table created
SQL> ALTER TABLE TB_JMS_DADATB
2 ADD PRIMARY KEY (INTER_NAME, PROV_CD, CUSTOMER_TARGET)
3 USING INDEX
4 TABLESPACE TDXTIDX;
Table altered
SQL> CREATE TABLE TB_JMS_QUEUES (
2 QUEUE_NAME VARCHAR2(20) NOT NULL,
3 PROV_CD CHAR(2) NOT NULL,
4 QUEUE_LEV CHAR(1) NULL,
5 RECVSEND_IND CHAR(1) NULL
6 );
Table created
SQL> ALTER TABLE TB_JMS_QUEUES
2 ADD PRIMARY KEY (QUEUE_NAME, PROV_CD)
3 USING INDEX
4 TABLESPACE TDXTIDX;
Table altered
SQL> CREATE TABLE TB_JMS_RECVCTL (
2 DATA_DATE CHAR(8) NOT NULL,
3 INTER_NAME VARCHAR2(20) NOT NULL,
4 FILE_NAME VARCHAR2(200) NOT NULL,
5 DATATB_NAME VARCHAR2(20) NOT NULL,
6 UPD_TIME DATE NOT NULL,
7 DATA_ROW_NUM NUMBER(12) NULL,
8 DEAL_IND CHAR(1) NULL
9 );
Table created
SQL> ALTER TABLE TB_JMS_RECVCTL
2 ADD PRIMARY KEY (DATA_DATE, INTER_NAME, FILE_NAME)
3 USING INDEX
4 TABLESPACE TDXTIDX;
Table altered
SQL> CREATE TABLE TB_JMS_SENDCTL (
2 DATA_DATE CHAR(8) NOT NULL,
3 INTER_NAME VARCHAR2(20) NOT NULL,
4 SEND_TYP CHAR(1) NOT NULL,
5 PROV_CD CHAR(2) NOT NULL,
6 QUEUE_NAME VARCHAR2(20) NOT NULL,
7 CUSTOMER_TARGET VARCHAR2(20) NOT NULL,
8 DATATB_NAME VARCHAR2(20) NOT NULL,
9 PARTITION_NAME VARCHAR2(20) NOT NULL,
10 UPD_TIME DATE NOT NULL,
11 DATA_ROW_NUM NUMBER(12) NULL,
12 DEAL_IND CHAR(1) NULL
13 );
Table created
SQL> ALTER TABLE TB_JMS_SENDCTL
2 ADD PRIMARY KEY (DATA_DATE, INTER_NAME, SEND_TYP, PROV_CD,
3 QUEUE_NAME, CUSTOMER_TARGET)
4 USING INDEX
5 TABLESPACE TDXTIDX;
Table altered
SQL> CREATE TABLE TB_RUN$LOG (
2 D_DEALDATE DATE NOT NULL,
3 V_LEVEL CHAR(1) NOT NULL,
4 V_LOGGERID VARCHAR2(30) NOT NULL,
5 V_MSGTAG VARCHAR2(200) NOT NULL,
6 V_QUEUENAME VARCHAR2(100) NOT NULL,
7 V_LOGCONTENT VARCHAR2(4000) NULL,
8 V_TX_ACTION CHAR(1) NULL,
9 TS_TX_TIME DATE NULL
10 );
Table created
SQL> ALTER TABLE TB_RUN$LOG
2 ADD PRIMARY KEY (D_DEALDATE, V_LEVEL, V_LOGGERID)
3 USING INDEX
4 TABLESPACE TDXTIDX;
Table altered
SQL> CREATE TABLE TD_SHPT_NJHZ_RECV (
2 V_ZBTM VARCHAR2(30) NOT NULL,
3 V_YJHM VARCHAR2(30) NOT NULL,
4 V_NJXH VARCHAR2(40) NOT NULL,
5 C_HZBZ CHAR(1) NULL,
6 V_HZHM VARCHAR2(30) NULL,
7 V_TX_ACTION CHAR(1) NULL,
8 TS_TX_TIME DATE NULL,
9 V_FNAME VARCHAR2(200) NULL
10 );
Table created
SQL> ALTER TABLE TD_SHPT_NJHZ_RECV
2 ADD PRIMARY KEY (V_ZBTM, V_YJHM, V_NJXH)
3 USING INDEX
4 TABLESPACE TDXTIDX;
Table altered
SQL> CREATE TABLE TD_SHPT_SHJG_RECV (
2 C_JGBH CHAR(8) NOT NULL,
3 V_JGMC VARCHAR2(100) NOT NULL,
4 V_JGJM VARCHAR2(50) NULL,
5 C_XZQH CHAR(6) NULL,
6 C_CZBZ CHAR(1) NULL,
7 D_GXRQ DATE NOT NULL,
8 V_TX_ACTION CHAR(1) NULL,
9 TS_TX_TIME DATE NULL,
10 V_FNAME VARCHAR2(200) NULL
11 );
Table created
SQL> ALTER TABLE TD_SHPT_SHJG_RECV
2 ADD PRIMARY KEY (C_JGBH)
3 USING INDEX
4 TABLESPACE TDXTIDX;
Table altered
SQL> CREATE TABLE TD_SHPT_SHKH_RECV (
2 N_YHID NUMBER NOT NULL,
3 V_YHBH VARCHAR2(20) NOT NULL,
4 V_YHMC VARCHAR2(100) NOT NULL,
5 V_YHJC VARCHAR2(20) NULL,
6 V_YHJM VARCHAR2(50) NOT NULL,
7 V_DZ VARCHAR2(200) NULL,
8 V_LXR VARCHAR2(20) NULL,
9 V_LXDH VARCHAR2(60) NULL,
10 C_JGBH CHAR(8) NOT NULL,
11 C_CZBZ CHAR(1) NULL,
12 V_TX_ACTION CHAR(1) NULL,
13 TS_TX_TIME DATE NULL,
14 V_FNAME VARCHAR2(200) NULL
15 );
Table created
SQL> ALTER TABLE TD_SHPT_SHKH_RECV
2 ADD PRIMARY KEY (N_YHID)
3 USING INDEX
4 TABLESPACE TDXTIDX;
Table altered
SQL> CREATE TABLE TD_SHPT_SHPC_RECV (
2 N_PCH NUMBER NOT NULL,
3 N_YWID NUMBER NOT NULL,
4 N_YHID NUMBER NOT NULL,
5 V_ZZPCH VARCHAR2(20) NULL,
6 V_PCMC VARCHAR2(30) NULL,
7 C_ZZJGBH CHAR(8) NOT NULL,
8 D_ZZRQ DATE NULL,
9 V_TX_ACTION CHAR(1) NULL,
10 TS_TX_TIME DATE NULL,
11 V_FNAME VARCHAR2(200) NULL
12 );
Table created
SQL> ALTER TABLE TD_SHPT_SHPC_RECV
2 ADD PRIMARY KEY (N_PCH)
3 USING INDEX
4 TABLESPACE TDXTIDX;
Table altered
SQL> CREATE TABLE TD_SHPT_SHYW_RECV (
2 N_YWID NUMBER NOT NULL,
3 V_YWZLDM VARCHAR2(10) NULL,
4 V_YWZLMC VARCHAR2(20) NOT NULL,
5 N_YHID NUMBER NOT NULL,
6 C_JGBH CHAR(8) NULL,
7 C_YWSX CHAR(1) NULL,
8 C_TDFS CHAR(1) NULL,
9 C_SHLB CHAR(1) NULL,
10 N_TDXS NUMBER NULL,
11 C_HZBZ CHAR(1) NULL,
12 N_SHHZSX CHAR(1) NULL,
13 C_CZBZ CHAR(1) NULL,
14 V_TX_ACTION CHAR(1) NULL,
15 TS_TX_TIME DATE NULL,
16 V_FNAME VARCHAR2(200) NULL
17 );
Table created
SQL> ALTER TABLE TD_SHPT_SHYW_RECV
2 ADD PRIMARY KEY (N_YWID)
3 USING INDEX
4 TABLESPACE TDXTIDX;
Table altered
SQL> CREATE TABLE TD_SHPT_SHZB_RECV (
2 V_ZBTM VARCHAR2(30) NOT NULL,
3 N_YHID NUMBER NULL,
4 N_YWID NUMBER NULL,
5 D_FFRQ DATE NULL,
6 V_FFR VARCHAR2(20) NULL,
7 C_FCJGBH CHAR(8) NOT NULL,
8 C_JSJGBH CHAR(8) NOT NULL,
9 N_YJJS NUMBER NULL,
10 C_ZBLX CHAR(1) NULL,
11 C_RQLX CHAR(1) NULL,
12 N_ZBJS NUMBER NULL,
13 V_TX_ACTION CHAR(1) NULL,
14 TS_TX_TIME DATE NULL,
15 V_FNAME VARCHAR2(200) NULL
16 );
Table created
SQL> ALTER TABLE TD_SHPT_SHZB_RECV
2 ADD PRIMARY KEY (V_ZBTM)
3 USING INDEX
4 TABLESPACE TDXTIDX;
Table altered
SQL> CREATE TABLE TD_SHPT_YJQD_RECV (
2 V_ZBTM VARCHAR2(30) NOT NULL,
3 V_YJHM VARCHAR2(30) NOT NULL,
4 N_YHID NUMBER NOT NULL,
5 N_YWID NUMBER NOT NULL,
6 N_PCH NUMBER NULL,
7 V_YWGJZ VARCHAR2(50) NULL,
8 V_SJRDZ VARCHAR2(250) NOT NULL,
9 V_SJRDZID VARCHAR2(14) NULL,
10 V_SJRXM VARCHAR2(150) NOT NULL,
11 V_SJRYB VARCHAR2(8) NULL,
12 C_TDJH CHAR(8) NOT NULL,
13 N_TDD NUMBER(6) NULL,
14 N_TDSX NUMBER(11,4) NULL,
15 C_ZZJGBH CHAR(8) NOT NULL,
16 V_YJZLDM CHAR(1) NOT NULL,
17 C_YJSX CHAR(1) NOT NULL,
18 C_HZYQ CHAR(1) NULL,
19 V_HZHM VARCHAR2(30) NULL,
20 V_TX_ACTION CHAR(1) NULL,
21 TS_TX_TIME DATE NULL,
22 V_FNAME VARCHAR2(200) NULL
23 );
Table created
SQL> ALTER TABLE TD_SHPT_YJQD_RECV
2 ADD PRIMARY KEY (V_ZBTM, V_YJHM)
3 USING INDEX
4 TABLESPACE TDXTIDX;
Table altered
SQL> CREATE TABLE TD_SHPT_YWTZ_RECV (
2 V_XXLX VARCHAR2(10) NOT NULL,
3 V_XXBH VARCHAR2(40) NOT NULL,
4 C_FSJGBH CHAR(8) NULL,
5 C_JSJGBH CHAR(8) NULL,
6 V_BT VARCHAR2(300) NULL,
7 V_NN VARCHAR2(300) NULL,
8 V_BZ VARCHAR2(300) NULL,
9 D_TZRQ DATE NULL,
10 D_YXRQ DATE NULL,
11 V_TX_ACTION CHAR(1) NULL,
12 TS_TX_TIME DATE NULL,
13 V_FNAME VARCHAR2(200) NULL
14 );
Table created
SQL> ALTER TABLE TD_SHPT_YWTZ_RECV
2 ADD PRIMARY KEY (V_XXLX, V_XXBH)
3 USING INDEX
4 TABLESPACE TDXTIDX;
Table altered
SQL> CREATE TABLE TDGL_T_BSXZQHB (
2 C_QXXZQH CHAR(6) NOT NULL,
3 V_QXMC VARCHAR2(20) NOT NULL,
4 C_DSXZQH CHAR(6) NOT NULL,
5 V_DSMC VARCHAR2(20) NOT NULL,
6 C_SJXZQH CHAR(6) NOT NULL,
7 V_SJMC VARCHAR2(20) NOT NULL
8 );
Table created
SQL> ALTER TABLE TDGL_T_BSXZQHB
2 ADD PRIMARY KEY (C_QXXZQH)
3 USING INDEX
4 TABLESPACE TDXTIDX;
Table altered
SQL> CREATE TABLE TDGL_T_DDTZXXTJ (
2 D_TJRQ DATE NOT NULL,
3 C_TDJH CHAR(8) NOT NULL,
4 D_TDRQ DATE NOT NULL,
5 N_TDBC NUMBER(1) NOT NULL,
6 V_TDXX VARCHAR2(100) NOT NULL,
7 D_CZSJ DATE NOT NULL,
8 V_JGMC VARCHAR2(16) NOT NULL,
9 C_XSJBH CHAR(8) NULL,
10 C_DSJBH CHAR(8) NULL,
11 C_SJBH CHAR(8) NULL
12 );
Table created
SQL> ALTER TABLE TDGL_T_DDTZXXTJ
2 ADD PRIMARY KEY (D_TJRQ, C_TDJH, D_TDRQ, N_TDBC, V_TDXX,
3 D_CZSJ)
4 USING INDEX
5 TABLESPACE TDXTIDX;
Table altered
SQL> CREATE TABLE TDGL_T_DJLOG (
2 D_TJRQ DATE NOT NULL,
3 V_TJDM VARCHAR2(10) NOT NULL,
4 D_RUNTIME DATE NOT NULL,
5 V_XMMC VARCHAR2(50) NULL
6 );
Table created
SQL> ALTER TABLE TDGL_T_DJLOG
2 ADD PRIMARY KEY (D_TJRQ, V_TJDM, D_RUNTIME)
3 USING INDEX
4 TABLESPACE TDXTIDX;
Table altered
SQL> CREATE TABLE TDGL_T_DSBHDZB (
2 C_XH NUMBER(2) NOT NULL,
3 C_DSJBH CHAR(8) NOT NULL,
4 V_DQMC VARCHAR2(18) NOT NULL,
5 C_SJBH CHAR(8) NULL
6 );
Table created
SQL> ALTER TABLE TDGL_T_DSBHDZB
2 ADD PRIMARY KEY (C_XH, C_DSJBH, V_DQMC)
3 USING INDEX
4 TABLESPACE TDXTIDX;
Table altered
SQL> CREATE TABLE TDGL_T_FFLTJ (
2 C_TDJH CHAR(8) NOT NULL,
3 D_TJRQ DATE NOT NULL,
4 N_BC NUMBER(1) NOT NULL,
5 V_YJZLDM VARCHAR2(6) NOT NULL,
6 V_YJZLMC VARCHAR2(20) NULL,
7 N_JKJS NUMBER(5) NULL,
8 N_CKJS NUMBER(5) NULL,
9 N_CKZB NUMBER(5) NULL
10 );
Table created
SQL> ALTER TABLE TDGL_T_FFLTJ
2 ADD PRIMARY KEY (C_TDJH, D_TJRQ, N_BC, V_YJZLDM)
3 USING INDEX
4 TABLESPACE TDXTIDX;
Table altered
SQL> CREATE TABLE TDGL_T_FJYGZLTJ (
2 D_TJRQ DATE NOT NULL,
3 D_LRRQ DATE NOT NULL,
4 C_TDJH CHAR(8) NOT NULL,
5 C_FJYGH CHAR(4) NOT NULL,
6 N_LRBC NUMBER(1) NOT NULL,
7 C_TX CHAR(2) NOT NULL,
8 V_YJZLDM VARCHAR2(6) NOT NULL,
9 V_YJZLMC VARCHAR2(16) NOT NULL,
10 V_JGMC VARCHAR2(16) NOT NULL,
11 C_XSJBH CHAR(8) NULL,
12 C_DSJBH CHAR(8) NULL,
13 C_SJBH CHAR(8) NULL,
14 V_YGXM VARCHAR2(10) NULL,
15 N_FJGZL NUMBER(10) NULL
16 );
Table created
SQL> ALTER TABLE TDGL_T_FJYGZLTJ
2 ADD PRIMARY KEY (D_TJRQ, D_LRRQ, C_TDJH, C_FJYGH, N_LRBC, C_TX,
3 V_YJZLDM, V_YJZLMC)
4 USING INDEX
5 TABLESPACE TDXTIDX;
Table altered
SQL> CREATE TABLE TDGL_T_JGXZQHB (
2 C_TDJH CHAR(8) NOT NULL,
3 V_JGMC VARCHAR2(20) NOT NULL,
4 C_QXXZQH CHAR(6) NOT NULL,
5 C_DSXZQH CHAR(6) NOT NULL,
6 C_SJXZQH CHAR(6) NOT NULL,
7 C_SQBZ CHAR(1) NULL
8 );
Table created
SQL> ALTER TABLE TDGL_T_JGXZQHB
2 ADD PRIMARY KEY (C_TDJH)
3 USING INDEX
4 TABLESPACE TDXTIDX;
Table altered
SQL> CREATE TABLE TDGL_T_JXKHQZCS (
2 V_QZCSTM VARCHAR2(14) NOT NULL,
3 C_TDJH CHAR(8) NOT NULL,
4 V_YJZLDM VARCHAR2(6) NOT NULL,
5 N_TTYJQZZS NUMBER(3,2) NULL,
6 N_TDDZQZZS NUMBER(3,2) NULL,
7 N_YJZLQZZS NUMBER(3,2) NULL,
8 N_ZLCQZZS NUMBER(3,2) NULL,
9 C_SXBZ CHAR(1) NULL,
10 D_XGRQ DATE NULL
11 );
Table created
SQL> ALTER TABLE TDGL_T_JXKHQZCS
2 ADD PRIMARY KEY (V_QZCSTM)
3 USING INDEX
4 TABLESPACE TDXTIDX;
Table altered
SQL> CREATE TABLE TDGL_T_JZFJGZLTJ (
2 D_TJRQ DATE NOT NULL,
3 D_LRRQ DATE NOT NULL,
4 C_CLJH CHAR(8) NOT NULL,
5 C_TDJH CHAR(8) NOT NULL,
6 C_FJYGH CHAR(4) NOT NULL,
7 N_LRBC NUMBER(1) NOT NULL,
8 C_TX CHAR(2) NOT NULL,
9 V_YJZLDM VARCHAR2(6) NOT NULL,
10 V_YJZLMC VARCHAR2(16) NOT NULL,
11 V_CLJJGMC VARCHAR2(16) NOT NULL,
12 V_TDJGMC VARCHAR2(16) NOT NULL,
13 C_XSJBH CHAR(8) NULL,
14 C_DSJBH CHAR(8) NULL,
15 C_SJBH CHAR(8) NULL,
16 V_YGXM VARCHAR2(10) NULL,
17 N_FJGZL NUMBER(10) NULL
18 );
Table created
SQL> ALTER TABLE TDGL_T_JZFJGZLTJ
2 ADD PRIMARY KEY (D_TJRQ, D_LRRQ, C_CLJH, C_TDJH, C_FJYGH,
3 N_LRBC, C_TX, V_YJZLDM, V_YJZLMC)
4 USING INDEX
5 TABLESPACE TDXTIDX;
Table altered
SQL> CREATE TABLE TDGL_T_MZBGXX (
2 D_TJRQ DATE NOT NULL,
3 C_TDJH CHAR(8) NOT NULL,
4 D_CZRQ DATE NOT NULL,
5 V_SFMC VARCHAR2(10) NOT NULL,
6 V_JGMC VARCHAR2(16) NOT NULL,
7 C_XSJBH CHAR(8) NULL,
8 C_DSJBH CHAR(8) NULL,
9 C_SJBH CHAR(8) NULL,
10 N_MZBGS NUMBER(10) NULL
11 );
Table created
SQL> ALTER TABLE TDGL_T_MZBGXX
2 ADD PRIMARY KEY (D_TJRQ, C_TDJH, D_CZRQ, V_SFMC)
3 USING INDEX
4 TABLESPACE TDXTIDX;
Table altered
SQL> CREATE TABLE TDGL_T_PCTDCLB (
2 D_TJRQ DATE NOT NULL,
3 C_JGBH CHAR(8) NOT NULL,
4 C_TDYGH CHAR(4) NOT NULL,
5 N_TDBC NUMBER(1) NOT NULL,
6 N_TDD NUMBER(6) NOT NULL,
7 V_YJZLDM VARCHAR2(6) NOT NULL,
8 V_TDBZDM VARCHAR2(2) NOT NULL,
9 C_XSJBH CHAR(8) NULL,
10 V_JGMC VARCHAR2(16) NULL,
11 V_TDYGXM VARCHAR2(20) NULL,
12 V_YJZLMC VARCHAR2(20) NULL,
13 C_DSJBH CHAR(8) NULL,
14 C_SJBH CHAR(8) NULL,
15 V_TDBZMC VARCHAR2(20) NULL,
16 N_TDJS NUMBER(6) NULL,
17 N_TDDZS NUMBER(6) NULL
18 );
Table created
SQL> ALTER TABLE TDGL_T_PCTDCLB
2 ADD PRIMARY KEY (D_TJRQ, C_JGBH, C_TDYGH, N_TDBC, N_TDD,
3 V_YJZLDM, V_TDBZDM)
4 USING INDEX
5 TABLESPACE TDXTIDX;
Table altered
SQL> CREATE TABLE TDGL_T_PCTDYCLB (
2 D_TJRQ DATE NOT NULL,
3 C_JGBH CHAR(8) NOT NULL,
4 C_TDYGH CHAR(4) NOT NULL,
5 V_YJZLDM VARCHAR2(6) NOT NULL,
6 V_TDBZDM VARCHAR2(2) NOT NULL,
7 N_TDD NUMBER(6) NOT NULL,
8 N_TDBC NUMBER(1) NOT NULL,
9 V_JGMC VARCHAR2(16) NULL,
10 C_XSJBH CHAR(8) NULL,
11 C_DSJBH CHAR(8) NULL,
12 C_SJBH CHAR(8) NULL,
13 D_TDRQ DATE NULL,
14 V_TDYGXM VARCHAR2(20) NULL,
15 V_YJZLMC VARCHAR2(20) NULL,
16 V_TDBZMC VARCHAR2(20) NULL,
17 N_TDJS NUMBER(6) NULL,
18 N_TDDZS NUMBER(6) NULL
19 );
Table created
SQL> ALTER TABLE TDGL_T_PCTDYCLB
2 ADD PRIMARY KEY (D_TJRQ, C_JGBH, C_TDYGH, V_YJZLDM, V_TDBZDM,
3 N_TDD, N_TDBC)
4 USING INDEX
5 TABLESPACE TDXTIDX;
Table altered
SQL> CREATE TABLE TDGL_T_RJJJLCTJ (
2 D_TJRQ DATE NOT NULL,
3 C_TDJH CHAR(8) NOT NULL,
4 N_TDD NUMBER(6) NOT NULL,
5 C_TJBZ CHAR(1) NOT NULL,
6 V_JGMC VARCHAR2(20) NULL,
7 V_DDMC VARCHAR2(20) NULL,
8 C_TDDLXMC VARCHAR2(20) NULL,
9 N_PYTTS NUMBER(10) NULL,
10 N_GHTTS NUMBER(10) NULL,
11 N_TKTTS NUMBER(10) NULL,
12 N_QTTTS NUMBER(10) NULL,
13 N_JJD NUMBER(10) NULL,
14 N_LCS NUMBER(10) NULL,
15 C_XSJBH CHAR(8) NULL,
16 C_DSJBH CHAR(8) NOT NULL,
17 C_SJBH CHAR(8) NOT NULL
18 );
Table created
SQL> ALTER TABLE TDGL_T_RJJJLCTJ
2 ADD PRIMARY KEY (D_TJRQ, C_TDJH, N_TDD, C_TJBZ)
3 USING INDEX
4 TABLESPACE TDXTIDX;
Table altered
SQL> CREATE TABLE TDGL_T_SHHZTJ (
2 D_TJRQ DATE NOT NULL,
3 C_TDJH CHAR(8) NOT NULL,
4 C_YGH CHAR(4) NOT NULL,
5 V_JGMC VARCHAR2(16) NOT NULL,
6 C_XSJBH CHAR(8) NULL,
7 C_DSJBH CHAR(8) NULL,
8 C_SJBH CHAR(8) NULL,
9 V_YGXM VARCHAR2(10) NULL,
10 N_SHHZJS NUMBER(10) NULL
11 );
Table created
SQL> ALTER TABLE TDGL_T_SHHZTJ
2 ADD PRIMARY KEY (D_TJRQ, C_TDJH, C_YGH)
3 USING INDEX
4 TABLESPACE TDXTIDX;
Table altered
SQL> CREATE TABLE TDGL_T_SHTJTJ (
2 D_TJRQ DATE NOT NULL,
3 C_TDJH CHAR(8) NOT NULL,
4 N_TDD NUMBER(6) NOT NULL,
5 N_TDBC NUMBER(1) NOT NULL,
6 V_YJZLDM VARCHAR2(6) NOT NULL,
7 V_YJZLMC VARCHAR2(16) NOT NULL,
8 V_JGMC VARCHAR2(16) NOT NULL,
9 C_XSJBH CHAR(8) NULL,
10 C_DSJBH CHAR(8) NULL,
11 C_SJBH CHAR(8) NULL,
12 N_SHTJS NUMBER(10) NULL
13 );
Table created
SQL> ALTER TABLE TDGL_T_SHTJTJ
2 ADD PRIMARY KEY (D_TJRQ, C_TDJH, N_TDD, N_TDBC,
3 V_YJZLDM, V_YJZLMC)
4 USING INDEX
5 TABLESPACE TDXTIDX;
Table altered
SQL> CREATE TABLE TDGL_T_SHYWLTJ (
2 D_TJRQ DATE NOT NULL,
3 D_TDRQ DATE NOT NULL,
4 C_TDJH CHAR(8) NOT NULL,
5 N_YHID NUMBER NOT NULL,
6 C_TDYGH CHAR(4) NOT NULL,
7 N_TDD NUMBER(6) NOT NULL,
8 N_TDBC NUMBER(1) NOT NULL,
9 V_YJZLDM VARCHAR2(6) NOT NULL,
10 V_YJZLMC VARCHAR2(16) NOT NULL,
11 N_YWID NUMBER NOT NULL,
12 V_JGMC VARCHAR2(16) NULL,
13 V_YHMC VARCHAR2(100) NULL,
14 C_KFJGBH CHAR(8) NULL,
15 V_KFJGMC VARCHAR2(100) NULL,
16 C_XSJBH CHAR(8) NULL,
17 C_DSJBH CHAR(8) NULL,
18 C_SJBH CHAR(8) NULL,
19 V_YGXM VARCHAR2(10) NULL,
20 V_YWZLDM VARCHAR2(10) NULL,
21 V_YWZLMC VARCHAR2(20) NULL,
22 N_YJS NUMBER(10) NULL,
23 N_YJLRS NUMBER(10) NULL,
24 N_TTYJS NUMBER(10) NULL,
25 N_TJS NUMBER(10) NULL,
26 N_ZCTYJS NUMBER(10) NULL,
27 N_TDDZS NUMBER(10) NULL,
28 N_YJZL NUMBER(10,2) NULL,
29 N_TDHZJS NUMBER(10) NULL
30 );
Table created
SQL> ALTER TABLE TDGL_T_SHYWLTJ
2 ADD PRIMARY KEY (D_TJRQ, D_TDRQ, C_TDJH, N_YHID, C_TDYGH,
3 N_TDD, N_TDBC, V_YJZLDM, V_YJZLMC, N_YWID)
4 USING INDEX
5 TABLESPACE TDXTIDX;
Table altered
SQL> CREATE TABLE TDGL_T_SJBHDZB (
2 C_XH NUMBER(2) NOT NULL,
3 C_SJBH CHAR(8) NOT NULL,
4 V_DQMC VARCHAR2(18) NOT NULL
5 );
Table created
SQL> ALTER TABLE TDGL_T_SJBHDZB
2 ADD PRIMARY KEY (C_XH, C_SJBH, V_DQMC)
3 USING INDEX
4 TABLESPACE TDXTIDX;
Table altered
SQL> CREATE TABLE TDGL_T_TDGBDJB (
2 C_TDJH CHAR(8) NOT NULL,
3 N_TDD NUMBER(6) NOT NULL,
4 N_TDBC NUMBER(1) NOT NULL,
5 D_LRRQ DATE NOT NULL,
6 V_YJZLDM CHARACTER(6) NOT NULL,
7 N_TDYJS NUMBER(10) NULL,
8 N_LDCJS NUMBER(10) NULL,
9 N_TDQZS NUMBER(10) NULL,
10 N_QDKPHDS NUMBER(10) NULL,
11 N_YJCCS NUMBER(10) NULL,
12 V_JGMC VARCHAR2(16) NULL,
13 V_YJZLMC VARCHAR2(16) NULL
14 );
Table created
SQL> ALTER TABLE TDGL_T_TDGBDJB
2 ADD PRIMARY KEY (C_TDJH, N_TDD, N_TDBC, D_LRRQ)
3 USING INDEX
4 TABLESPACE TDXTIDX;
Table altered
SQL> CREATE TABLE TDGL_T_TDJCLTJ (
2 D_TJRQ DATE NOT NULL,
3 D_TDRQ DATE NOT NULL,
4 C_TDJH CHAR(8) NOT NULL,
5 C_TDYGH CHAR(4) NOT NULL,
6 N_TDD NUMBER(6) NOT NULL,
7 N_TDBC NUMBER(1) NOT NULL,
8 V_YJZLDM VARCHAR2(6) NOT NULL,
9 V_YJZLMC VARCHAR2(16) NOT NULL,
10 C_XSJBH CHAR(8) NULL,
11 C_DSJBH CHAR(8) NULL,
12 C_SJBH CHAR(8) NULL,
13 V_YGXM VARCHAR2(10) NULL,
14 N_YJS NUMBER(10) NULL,
15 N_YJLRS NUMBER(10) NULL,
16 N_TTYJS NUMBER(10) NULL,
17 N_TJS NUMBER(10) NULL,
18 N_ZCTYJS NUMBER(10) NULL,
19 N_TDDZS NUMBER(10) NULL,
20 N_YJZL NUMBER(10,2) NULL,
21 N_TDHZJS NUMBER(10) NULL
22 );
Table created
SQL> ALTER TABLE TDGL_T_TDJCLTJ
2 ADD PRIMARY KEY (D_TJRQ, D_TDRQ, C_TDJH, C_TDYGH, N_TDD,
3 N_TDBC, V_YJZLDM, V_YJZLMC)
4 USING INDEX
5 TABLESPACE TDXTIDX;
Table altered
SQL> CREATE TABLE TDGL_T_TDSXJCB (
2 V_TDSXDM VARCHAR2(36) NOT NULL,
3 C_TDJH VARCHAR2(8) NOT NULL,
4 V_YJZLDM VARCHAR2(6) NOT NULL,
5 N_TDD NUMBER(6) NOT NULL,
6 N_BC NUMBER(1) NOT NULL,
7 N_TDSX NUMBER(6,2) NULL,
8 N_FBSX NUMBER(6,2) NULL
9 );
Table created
SQL> ALTER TABLE TDGL_T_TDSXJCB
2 ADD PRIMARY KEY (V_TDSXDM, C_TDJH, V_YJZLDM, N_TDD, N_BC)
3 USING INDEX
4 TABLESPACE TDXTIDX;
Table altered
SQL> CREATE TABLE TDGL_T_TDWDFFTJ (
2 D_TJRQ DATE NOT NULL,
3 C_TDJH CHAR(8) NOT NULL,
4 C_TDYGH CHAR(4) NOT NULL,
5 N_TDBC NUMBER(1) NOT NULL,
6 C_XSJBH CHAR(8) NULL,
7 V_JGMC VARCHAR2(16) NULL,
8 N_DSHK NUMBER(10) NULL,
9 F_DSHK NUMBER(10,2) NULL,
10 N_SJRFF NUMBER(10) NULL,
11 C_DSJBH CHAR(8) NULL,
12 C_SJBH CHAR(8) NULL,
13 F_SJRFF NUMBER(10,2) NULL
14 );
Table created
SQL> ALTER TABLE TDGL_T_TDWDFFTJ
2 ADD PRIMARY KEY (D_TJRQ, C_TDJH, C_TDYGH, N_TDBC)
3 USING INDEX
4 TABLESPACE TDXTIDX;
Table altered
SQL> CREATE TABLE TDGL_T_TDYJLLLX (
2 D_TJRQ DATE NOT NULL,
3 C_TDJH CHAR(8) NOT NULL,
4 V_YJZLDM VARCHAR2(6) NOT NULL,
5 V_YJZLMC VARCHAR2(20) NOT NULL,
6 V_JGMC VARCHAR2(20) NULL,
7 C_XSJBH CHAR(8) NULL,
8 C_DSJBH CHAR(8) NULL,
9 C_SJBH CHAR(8) NULL,
10 N_ZYJS NUMBER(10) NULL,
11 N_BQYJS NUMBER(10) NULL,
12 N_BSQYJS NUMBER(10) NULL,
13 N_QTXSYJS NUMBER(10) NULL,
14 N_BDSYJS NUMBER(10) NULL,
15 N_BSFWYJS NUMBER(10) NULL,
16 N_WSYJS NUMBER(10) NULL,
17 N_GJYJS NUMBER(10) NULL
18 );
Table created
SQL> ALTER TABLE TDGL_T_TDYJLLLX
2 ADD PRIMARY KEY (D_TJRQ, C_TDJH, V_YJZLDM, V_YJZLMC)
3 USING INDEX
4 TABLESPACE TDXTIDX;
Table altered
SQL> CREATE TABLE TDGL_T_XSBHDZB (
2 C_XH NUMBER(2) NOT NULL,
3 C_XSJBH CHAR(8) NOT NULL,
4 V_DQMC VARCHAR2(18) NOT NULL,
5 C_DSJBH CHAR(8) NOT NULL
6 );
Table created
SQL> ALTER TABLE TDGL_T_XSBHDZB
2 ADD PRIMARY KEY (C_XH, C_XSJBH, V_DQMC)
3 USING INDEX
4 TABLESPACE TDXTIDX;
Table altered
SQL> CREATE TABLE TDGL_T_XTCS (
2 V_CSDH VARCHAR2(20) NOT NULL,
3 V_CSMC VARCHAR2(20) NULL,
4 N_CSZ NUMBER(1) NOT NULL,
5 C_SXBZ CHAR(1) NULL,
6 C_YGH CHAR(8) NULL,
7 D_XGRQ DATE NOT NULL
8 );
Table created
SQL> ALTER TABLE TDGL_T_XTCS
2 ADD PRIMARY KEY (V_CSDH)
3 USING INDEX
4 TABLESPACE TDXTIDX;
Table altered
SQL> CREATE TABLE TDGL_T_YJSXXXB (
2 D_TJRQ DATE NOT NULL,
3 C_TDJH CHAR(8) NOT NULL,
4 N_TDD NUMBER(6) NOT NULL,
5 N_TDBC NUMBER(1) NOT NULL,
6 V_YJZLDM VARCHAR2(6) NOT NULL,
7 N_YJLSH NUMBER(10) NOT NULL,
8 V_YJHM VARCHAR2(28) NOT NULL,
9 D_LRSJ DATE NULL,
10 D_FBSJ DATE NULL,
11 D_GBSJ DATE NULL,
12 D_XHRQ DATE NULL
13 );
Table created
SQL> ALTER TABLE TDGL_T_YJSXXXB
2 ADD PRIMARY KEY (D_TJRQ, C_TDJH, N_TDD, N_TDBC, V_YJZLDM,
3 N_YJLSH, V_YJHM)
4 USING INDEX
5 TABLESPACE TDXTIDX;
Table altered
SQL> CREATE TABLE TDGL_T_YWTZB (
2 N_FBLSH NUMBER(6) NOT NULL,
3 V_DXJGBHLB VARCHAR2(278) NULL,
4 V_DXJGMCLB VARCHAR2(526) NULL,
5 V_DXJGYHLB VARCHAR2(4000) NULL,
6 V_DXJGYHMCLB VARCHAR2(4000) NULL,
7 V_FBZT VARCHAR2(50) NULL,
8 V_FBNR VARCHAR2(1000) NULL,
9 V_FJMC VARCHAR2(38) NULL,
10 D_SXSJ DATE NOT NULL,
11 N_FBBZ NUMBER(1) NULL,
12 V_FBRYNO VARCHAR2(100) NULL,
13 V_FBRYJGBH CHAR(8) NULL,
14 N_JSBZ NUMBER(1) NULL
15 );
Table created
SQL> ALTER TABLE TDGL_T_YWTZB
2 ADD PRIMARY KEY (N_FBLSH)
3 USING INDEX
4 TABLESPACE TDXTIDX;
Table altered
SQL> CREATE TABLE TDGL_T_YWTZJKFSB (
2 V_DXJGBH CHAR(8) NOT NULL,
3 N_FBLSH NUMBER(6) NOT NULL
4 );
Table created
SQL> ALTER TABLE TDGL_T_YWTZJKFSB
2 ADD PRIMARY KEY (V_DXJGBH, N_FBLSH)
3 USING INDEX
4 TABLESPACE TDXTIDX;
Table altered
SQL> CREATE TABLE TDGL_T_ZDTJDJB (
2 D_TJRQ DATE NOT NULL,
3 V_TJDM VARCHAR2(10) NOT NULL,
4 V_TJSM VARCHAR2(50) NOT NULL,
5 N_STATUS NUMBER(1) NOT NULL,
6 V_ERRM VARCHAR2(500) NULL,
7 D_RUNTIME DATE NOT NULL
8 );
Table created
SQL> ALTER TABLE TDGL_T_ZDTJDJB
2 ADD PRIMARY KEY (D_TJRQ, V_TJDM)
3 USING INDEX
4 TABLESPACE TDXTIDX;
Table altered
SQL> CREATE TABLE YZTD_T_BZCLB (
2 C_CLJH CHAR(8) NOT NULL,
3 D_CLRQ DATE NOT NULL,
4 C_TDJH CHAR(8) NOT NULL,
5 V_XMDM VARCHAR2(10) NOT NULL,
6 C_TXDM CHAR(2) NULL,
7 C_YGH CHAR(4) NULL,
8 V_YGXM VARCHAR2(20) NULL,
9 N_JS NUMBER(7) NULL
10 );
Table created
SQL> ALTER TABLE YZTD_T_BZCLB
2 ADD PRIMARY KEY (C_CLJH, D_CLRQ, C_TDJH, V_XMDM)
3 USING INDEX
4 TABLESPACE TDXTIDX;
Table altered
SQL> CREATE TABLE YZTD_T_BZCPB (
2 C_CLJH CHAR(8) NOT NULL,
3 D_CLRQ DATE NOT NULL,
4 V_XMDM VARCHAR2(10) NOT NULL,
5 C_TXDM CHAR(2) NULL,
6 C_YGH CHAR(4) NULL,
7 V_YGXM VARCHAR2(20) NULL,
8 N_JS NUMBER(7) NULL
9 );
Table created
SQL> ALTER TABLE YZTD_T_BZCPB
2 ADD PRIMARY KEY (C_CLJH, D_CLRQ, V_XMDM)
3 USING INDEX
4 TABLESPACE TDXTIDX;
Table altered
SQL> CREATE TABLE YZTD_T_BZZLB (
2 C_CLJH CHAR(8) NOT NULL,
3 D_CLRQ DATE NOT NULL,
4 C_TDJH CHAR(8) NOT NULL,
5 V_XMDM VARCHAR2(10) NOT NULL,
6 C_TXDM CHAR(2) NULL,
7 C_YGH CHAR(4) NULL,
8 V_YGXM VARCHAR2(20) NULL,
9 N_JS NUMBER(7) NULL
10 );
Table created
SQL> ALTER TABLE YZTD_T_BZZLB
2 ADD PRIMARY KEY (C_CLJH, D_CLRQ, C_TDJH, V_XMDM)
3 USING INDEX
4 TABLESPACE TDXTIDX;
Table altered
SQL> CREATE TABLE YZTD_T_CJYJB (
2 N_CJLSH NUMBER(10) NOT NULL,
3 N_YJLSH NUMBER(10) NOT NULL,
4 V_YJHM VARCHAR2(28) NULL,
5 V_YJZLDM VARCHAR2(6) NULL,
6 V_YJZLMC VARCHAR2(16) NULL,
7 C_TDJH CHAR(8) NULL,
8 V_SJRDZ VARCHAR2(120) NULL,
9 V_SJDWMC VARCHAR2(60) NULL,
10 V_SJRXM VARCHAR2(20) NULL,
11 C_SJRYB CHAR(6) NULL,
12 V_JJRDZ VARCHAR2(120) NULL,
13 V_JJRXM VARCHAR2(20) NULL,
14 C_JJRYB CHAR(6) NULL,
15 V_SJJMC VARCHAR2(60) NULL,
16 C_XZQH CHAR(6) NULL,
17 N_TDD NUMBER(6) NULL,
18 N_TDSX NUMBER(11,4) NULL,
19 V_DZID VARCHAR2(14) NULL,
20 V_DWID VARCHAR2(14) NULL,
21 V_ZTDZID VARCHAR2(14) NULL,
22 N_YJJS NUMBER(4) NULL,
23 C_CJLX CHAR(1) NULL,
24 D_LRRQ DATE NULL,
25 N_LRBC NUMBER(1) NULL,
26 D_CJRQ DATE NULL,
27 N_CJBC NUMBER(1) NULL,
28 D_YTRQ DATE NULL,
29 N_YTBC NUMBER(1) NULL,
30 C_XHCL CHAR(1) NULL,
31 D_XHRQ DATE NULL,
32 N_XHBC NUMBER(1) NULL,
33 C_DZBZ CHAR(1) NULL,
34 F_QZF NUMBER(10,2) NULL,
35 F_DSHK NUMBER(10,2) NULL,
36 V_TDBZDM VARCHAR2(2) NULL,
37 V_YJBZDM VARCHAR2(2) NULL,
38 N_YJZL NUMBER(6) NULL,
39 N_YJTJ NUMBER(8) NULL,
40 C_YGH CHAR(4) NULL,
41 C_TX CHAR(2) NULL,
42 V_WTTYYDM VARCHAR2(6) NULL,
43 V_XBDZDM VARCHAR2(6) NULL,
44 V_ZTYYDM VARCHAR2(4) NULL,
45 C_CLBZ CHAR(1) NULL,
46 D_YCDYRQ DATE NULL,
47 D_ECDYRQ DATE NULL,
48 F_YQBGF NUMBER(7,2) NULL,
49 C_CJYGH CHAR(4) NULL,
50 C_CJTX CHAR(2) NULL,
51 C_XHYGH CHAR(4) NULL,
52 C_XHTX CHAR(2) NULL,
53 C_QSBZ CHAR(1) NULL,
54 C_ZJLX CHAR(1) NULL,
55 V_QSRZJHM VARCHAR2(35) NULL,
56 V_QSRXM VARCHAR2(100) NULL,
57 C_DLRZJLX CHAR(1) NULL,
58 V_DLRZJHM VARCHAR2(35) NULL,
59 V_DLRXM VARCHAR2(100) NULL,
60 D_YTCLRQ DATE NULL
61 )
62 TABLESPACE TDXTBIGDATA
63 ;
Table created
SQL> ALTER TABLE YZTD_T_CJYJB
2 ADD PRIMARY KEY (N_CJLSH)
3 USING INDEX
4 TABLESPACE TDXTBIGIDX;
Table altered
SQL> CREATE TABLE YZTD_T_CJYJPHB (
2 C_TDJH CHAR(8) NOT NULL,
3 D_TJRQ DATE NOT NULL,
4 N_BC NUMBER(1) NOT NULL,
5 V_YJZLDM VARCHAR2(6) NOT NULL,
6 N_SCS NUMBER(4) NULL,
7 N_JKS NUMBER(4) NULL,
8 N_XHS NUMBER(4) NULL,
9 N_ZFS NUMBER(4) NULL,
10 N_YTS NUMBER(4) NULL,
11 N_ZTS NUMBER(4) NULL,
12 N_JCS NUMBER(4) NULL,
13 N_ZCT NUMBER(4) NULL
14 );
Table created
SQL> ALTER TABLE YZTD_T_CJYJPHB
2 ADD PRIMARY KEY (C_TDJH, D_TJRQ, N_BC, V_YJZLDM)
3 USING INDEX
4 TABLESPACE TDXTIDX;
Table altered
SQL> CREATE TABLE YZTD_T_CLLRB (
2 D_RQ DATE NOT NULL,
3 N_BC NUMBER(1) NOT NULL,
4 C_TDJH CHAR(8) NOT NULL,
5 N_TDD NUMBER(6) NOT NULL,
6 V_YJZLDM VARCHAR2(6) NULL,
7 N_YJJS NUMBER(6) NULL,
8 N_YJZL NUMBER(8) NULL,
9 C_TDYGH CHAR(4) NULL
10 );
Table created
SQL> ALTER TABLE YZTD_T_CLLRB
2 ADD PRIMARY KEY (D_RQ, N_BC, C_TDJH, N_TDD)
3 USING INDEX
4 TABLESPACE TDXTIDX;
Table altered
SQL> CREATE TABLE YZTD_T_CTYJB (
2 N_YJLSH NUMBER(10) NOT NULL,
3 V_YJHM VARCHAR2(13) NULL,
4 V_YJZLDM VARCHAR2(6) NULL,
5 V_YJZLMC VARCHAR2(16) NULL,
6 C_TDJH CHAR(8) NULL,
7 D_FSRQ DATE NULL,
8 N_FSBC NUMBER(1) NULL,
9 C_YGH CHAR(4) NULL,
10 C_JSJH CHAR(8) NULL,
11 V_SJRDZ VARCHAR2(120) NULL,
12 V_SJDWMC VARCHAR2(60) NULL,
13 V_SJRXM VARCHAR2(20) NULL,
14 C_SJRYB CHAR(6) NULL,
15 V_JJRDZ VARCHAR2(120) NULL,
16 V_JJRXM VARCHAR2(20) NULL,
17 C_JJRYB CHAR(6) NULL,
18 V_SJJMC VARCHAR2(60) NULL,
19 N_TDD NUMBER(6) NULL,
20 N_TDSX NUMBER(11,4) NULL,
21 V_DZID VARCHAR2(14) NULL,
22 V_DWID VARCHAR2(14) NULL,
23 V_ZTDZID VARCHAR2(14) NULL,
24 N_YJJS NUMBER(4) NULL,
25 C_CJLX CHAR(1) NULL,
26 D_LRRQ DATE NULL,
27 N_LRBC NUMBER(1) NULL,
28 C_XHCL CHAR(1) NULL,
29 D_XHRQ DATE NULL,
30 N_XHBC NUMBER(1) NULL,
31 C_DZBZ CHAR(1) NULL,
32 F_QZF NUMBER(10,2) NULL,
33 F_DSHK NUMBER(10,2) NULL,
34 V_YJBZDM VARCHAR2(2) NULL,
35 N_YJZL NUMBER(6) NULL,
36 N_YJTJ NUMBER(8) NULL,
37 V_ZTYYDM VARCHAR2(4) NULL,
38 D_JSRQ DATE NULL,
39 N_JSBC NUMBER(1) NULL,
40 C_JSYGH CHAR(4) NULL,
41 N_JSZH NUMBER(6) NULL,
42 C_CLBZ CHAR(1) NULL,
43 D_YCDYRQ DATE NULL,
44 D_ECDYRQ DATE NULL,
45 F_YQBGF NUMBER(7,2) NULL,
46 C_QSBZ CHAR(1) NULL,
47 C_ZJLX CHAR(1) NULL,
48 V_QSRZJHM VARCHAR2(35) NULL,
49 V_QSRXM VARCHAR2(100) NULL,
50 C_DLRZJLX CHAR(1) NULL,
51 V_DLRZJHM VARCHAR2(35) NULL,
52 V_DLRXM VARCHAR2(100) NULL
53 )
54 TABLESPACE TDXTBIGDATA
55 ;
Table created
SQL> ALTER TABLE YZTD_T_CTYJB
2 ADD PRIMARY KEY (N_YJLSH)
3 USING INDEX
4 TABLESPACE TDXTBIGIDX;
Table altered
SQL> CREATE TABLE YZTD_T_CZRZ (
2 N_LSH NUMBER(10) NOT NULL,
3 N_YJLSH NUMBER(10) NULL,
4 C_YGH CHAR(4) NULL,
5 D_RQ DATE NULL,
6 V_XZBZ VARCHAR2(200) NULL,
7 V_YJHM VARCHAR2(28) NULL
8 )
9 TABLESPACE TDXTBIGDATA
10 ;
Table created
SQL> ALTER TABLE YZTD_T_CZRZ
2 ADD PRIMARY KEY (N_LSH)
3 USING INDEX
4 TABLESPACE TDXTBIGIDX;
Table altered
SQL> CREATE TABLE YZTD_T_DDXXB (
2 C_TDJH CHAR(8) NOT NULL,
3 N_TDD NUMBER(6) NOT NULL,
4 C_TDYWSX CHAR (1) NOT NULL,
5 V_DDMC VARCHAR2(16) NULL,
6 N_LCS NUMBER(10,2) NULL,
7 N_MBLCS NUMBER(10,2) NULL,
8 N_BBLCS NUMBER(10,2) NULL,
9 N_XBXS NUMBER(5) NULL,
10 C_TDDLX CHAR(1) NULL,
11 D_GXRQ DATE NULL,
12 C_CLBZ CHAR(1) NULL
13 );
Table created
SQL> ALTER TABLE YZTD_T_DDXXB
2 ADD PRIMARY KEY (C_TDJH, N_TDD, C_TDYWSX)
3 USING INDEX
4 TABLESPACE TDXTIDX;
Table altered
SQL> CREATE TABLE YZTD_T_DHDJ (
2 V_LSH VARCHAR2(25) NOT NULL,
3 C_JGBH CHAR(8) NOT NULL,
4 D_DJRQ DATE NOT NULL,
5 N_TDBC NUMBER(1) NOT NULL,
6 V_YDZLDM VARCHAR2(8) NOT NULL,
7 N_SCSL NUMBER(5) NULL,
8 N_QLSL NUMBER(5) NULL,
9 N_KCSL NUMBER(5) NULL,
10 N_DRSL NUMBER(5) NULL,
11 N_DCSL NUMBER(5) NULL,
12 N_FFSL NUMBER(5) NULL,
13 N_QTSL NUMBER(5) NULL,
14 N_JCSL NUMBER(5) NULL,
15 C_YGH CHAR(4) NULL,
16 V_YGXM VARCHAR(10) NULL,
17 V_YDZLMC VARCHAR2(40) NULL
18 );
Table created
SQL> ALTER TABLE YZTD_T_DHDJ
2 ADD PRIMARY KEY (V_LSH)
3 USING INDEX
4 TABLESPACE TDXTIDX;
Table altered
SQL> CREATE TABLE YZTD_T_DKHB (
2 N_DKHBH NUMBER(6) NOT NULL,
3 C_TDJH CHAR(8) NULL,
4 V_MCDM VARCHAR2(8) NULL,
5 V_DKHMC VARCHAR2(50) NULL,
6 V_DZID VARCHAR2(14) NULL,
7 V_DWID VARCHAR2(14) NULL
8 );
Table created
SQL> ALTER TABLE YZTD_T_DKHB
2 ADD PRIMARY KEY (N_DKHBH)
3 USING INDEX
4 TABLESPACE TDXTIDX;
Table altered
SQL> CREATE TABLE YZTD_T_FBB (
2 N_FBLSH NUMBER(8) NOT NULL,
3 C_CLJH CHAR(8) NOT NULL,
4 N_TDD NUMBER(6) NOT NULL,
5 N_BC NUMBER(1) NOT NULL,
6 D_RQ DATE NOT NULL,
7 C_TDJH CHAR(8) NOT NULL,
8 C_TX CHAR(2) NOT NULL,
9 N_SCS NUMBER(4) NULL,
10 N_JKS NUMBER(4) NULL,
11 N_HZYJS NUMBER(4) NULL,
12 N_QZDJS NUMBER(4) NULL,
13 N_QZJNTJS NUMBER(4) NULL,
14 D_FBSJ DATE NULL
15 )
16 TABLESPACE TDXTBIGDATA
17 ;
Table created
SQL> ALTER TABLE YZTD_T_FBB
2 ADD PRIMARY KEY (N_FBLSH, C_CLJH, N_TDD, N_BC, D_RQ, C_TDJH,
3 C_TX)
4 USING INDEX
5 TABLESPACE TDXTBIGIDX;
Table altered
SQL> CREATE TABLE YZTD_T_FBDJB (
2 C_TDJH CHAR(8) NOT NULL,
3 D_RQ DATE NOT NULL,
4 N_BC NUMBER(1) NOT NULL,
5 C_TX CHAR(2) NOT NULL,
6 D_FBSJ DATE NULL,
7 N_FBLSH NUMBER(8) NULL
8 )
9 TABLESPACE TDXTBIGDATA
10 ;
Table created
SQL> ALTER TABLE YZTD_T_FBDJB
2 ADD PRIMARY KEY (C_TDJH, D_RQ, N_BC, C_TX)
3 USING INDEX
4 TABLESPACE TDXTBIGIDX;
Table altered
SQL> CREATE TABLE YZTD_T_FFGXB (
2 C_TDJH CHAR(8) NOT NULL,
3 V_YJZLDM VARCHAR2(6) NOT NULL,
4 N_BC NUMBER(1) NOT NULL,
5 N_FFZLDH NUMBER(3) NULL,
6 V_QDCKBM VARCHAR2(16) NULL
7 );
Table created
SQL> ALTER TABLE YZTD_T_FFGXB
2 ADD PRIMARY KEY (C_TDJH, V_YJZLDM, N_BC)
3 USING INDEX
4 TABLESPACE TDXTIDX;
Table altered
SQL> CREATE TABLE YZTD_T_FFLSB (
2 C_TDJH CHAR(8) NOT NULL,
3 C_LX CHAR(1) NOT NULL,
4 N_DH NUMBER(3) NOT NULL,
5 N_DQH NUMBER(4) NULL,
6 N_QSH NUMBER(4) NULL,
7 N_ZZH NUMBER(4) NULL
8 );
Table created
SQL> ALTER TABLE YZTD_T_FFLSB
2 ADD PRIMARY KEY (C_TDJH, C_LX, N_DH)
3 USING INDEX
4 TABLESPACE TDXTIDX;
Table altered
SQL> CREATE TABLE YZTD_T_FFXXB (
2 C_TDJH CHAR(8) NOT NULL,
3 N_FFQDH NUMBER(8) NOT NULL,
4 N_FFZLDH NUMBER(3) NOT NULL,
5 D_FFRQ DATE NOT NULL,
6 N_FFBC NUMBER(1) NOT NULL,
7 V_FFMC VARCHAR2(16) NULL,
8 V_ZBTMZLDM VARCHAR2(4) NULL,
9 V_RQMC VARCHAR2(6) NULL,
10 C_FFYGH CHAR(4) NULL,
11 N_LDHM NUMBER(6) NULL,
12 N_LDZLDH NUMBER(3) NULL,
13 V_ZBTM VARCHAR2(30) NULL,
14 N_SL NUMBER(2) NULL,
15 C_TX CHAR(2) NULL,
16 V_QDCKBM VARCHAR2(16) NULL,
17 V_XJZDM VARCHAR2(8) NULL,
18 N_BZBZ NUMBER(1) NULL,
19 V_YLDM VARCHAR2(10) NULL,
20 V_ZBTMJSJDM VARCHAR2(8) NULL,
21 V_JSJMC VARCHAR2(20) NULL,
22 N_JJBZ NUMBER(1) NULL,
23 D_CZRQ DATE NULL,
24 N_SHBZ NUMBER(1) NULL
25 );
Table created
SQL> ALTER TABLE YZTD_T_FFXXB
2 ADD PRIMARY KEY (C_TDJH, N_FFQDH, N_FFZLDH, D_FFRQ, N_FFBC)
3 USING INDEX
4 TABLESPACE TDXTIDX;
Table altered
SQL> CREATE TABLE YZTD_T_FFZL (
2 N_FFZLDH NUMBER(3) NOT NULL,
3 V_FFDM VARCHAR2(4) NOT NULL,
4 V_FFMC VARCHAR2(16) NOT NULL,
5 V_ZBTMZLDM VARCHAR2(4) NULL,
6 C_QDCKJGBH CHAR(8) NULL,
7 V_QDCKJGMC VARCHAR2(16) NULL,
8 C_BZBZ CHAR(1) NULL
9 );
Table created
SQL> ALTER TABLE YZTD_T_FFZL
2 ADD PRIMARY KEY (N_FFZLDH)
3 USING INDEX
4 TABLESPACE TDXTIDX;
Table altered
SQL> CREATE TABLE YZTD_T_FJGXB (
2 C_JGBH CHAR(8) NOT NULL,
3 C_TX CHAR(2) NOT NULL,
4 C_TDJH VARCHAR2(16) NOT NULL,
5 V_TDJMC VARCHAR2(20) NULL,
6 V_MCDM VARCHAR2(10) NULL,
7 C_SFXF CHAR(1) NULL,
8 C_SFJK CHAR(1) NULL
9 );
Table created
SQL> ALTER TABLE YZTD_T_FJGXB
2 ADD PRIMARY KEY (C_JGBH, C_TX, C_TDJH)
3 USING INDEX
4 TABLESPACE TDXTIDX;
Table altered
SQL> CREATE TABLE YZTD_T_GBDJB (
2 C_TDJH CHAR(8) NOT NULL,
3 D_RQ DATE NOT NULL,
4 N_BC NUMBER(1) NOT NULL,
5 N_TDD NUMBER(6) NOT NULL,
6 D_GBSJ DATE NULL
7 )
8 TABLESPACE TDXTBIGDATA
9 ;
Table created
SQL> ALTER TABLE YZTD_T_GBDJB
2 ADD PRIMARY KEY (C_TDJH, D_RQ, N_BC, N_TDD)
3 USING INDEX
4 TABLESPACE TDXTBIGIDX;
Table altered
SQL> CREATE TABLE YZTD_T_GDYJS (
2 C_TDJH CHAR(8) NOT NULL,
3 D_RQ DATE NOT NULL,
4 N_BC NUMBER(1) NOT NULL,
5 N_TDD NUMBER(6) NOT NULL,
6 C_CLJH CHAR(8) NOT NULL,
7 N_SCS NUMBER(4) NULL,
8 N_JKS NUMBER(4) NULL
9 );
Table created
阅读(1663) | 评论(1) | 转发(0) |
