Chinaunix首页 | 论坛 | 博客
  • 博客访问: 3241599
  • 博文数量: 949
  • 博客积分: 10126
  • 博客等级: 上将
  • 技术积分: 12100
  • 用 户 组: 普通用户
  • 注册时间: 2006-06-16 10:57
文章分类

全部博文(949)

文章存档

2013年(1)

2012年(4)

2011年(4)

2010年(12)

2009年(342)

2008年(586)

分类: Oracle

2009-03-17 15:26:00

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
阅读(1671) | 评论(1) | 转发(0) |
0

上一篇:20090317tag1

下一篇:20090317tagall

给主人留下些什么吧!~~

chinaunix网友2009-05-07 17:12:17

好服月租型IT服务台登录中国,诚邀阁下莅临体验! 月租型ITSM软件,注册即可使用! 详情请登录官方网站:http://www.servicezon.com