-- Create table
create table T_DJ_JGNSRFB
(
nsrnbm      NUMBER(10) not null,
zyjycsmj    NUMBER(15,4),
zyjycsyz_je NUMBER(18,2),
czjycsmj    NUMBER(15,4),
czjycszj_je NUMBER(18,2),
czf_mc      VARCHAR2(80),
czflx_dh    VARCHAR2(30),
czfnsrnbm   NUMBER(10),
djslr_dm    VARCHAR2(11),
lrry_dm     VARCHAR2(11),
djzlshyj    VARCHAR2(100),
djzlsh_rq   DATE,
djzlshry_dm VARCHAR2(11),
gthjy_dz    VARCHAR2(80),
gthjyyb     VARCHAR2(6),
frgj_dm     CHAR(3),
frsfzhm     VARCHAR2(30),
dj_rq       DATE,
ysgzsdy_rq  DATE,
zxyhz_rq    DATE,
tjfl        CHAR(1),
gszch       VARCHAR2(40),
email_dz    VARCHAR2(50),
hsxs_dm     CHAR(2),
jzfs        CHAR(1),
gslx_dm     CHAR(2),
djtb_rq     DATE,
djtbr_mc    VARCHAR2(60),
sbjb_dm     CHAR(2),
tsqylb      CHAR(2),
tsqym       CHAR(3),
jyfwzy      VARCHAR2(1000),
jyfwjy      VARCHAR2(300),
lr_sj       TIMESTAMP(6) not null,
xg_sj       TIMESTAMP(6),
daglbm      VARCHAR2(20),
sdh_bz      CHAR(1),
nsrflm      VARCHAR2(20),
bz          VARCHAR2(150),
nsr_ywmc    VARCHAR2(200),
zldlb       VARCHAR2(1),
zdsy_bz     CHAR(1),
cwfzr_dh    VARCHAR2(30),
bsy_dh      VARCHAR2(30),
zczb        NUMBER(18,4),
zczb_sm     VARCHAR2(100),
bwtdzh_bz   CHAR(1),
swgllxr_bm  VARCHAR2(30),
zyyljly     VARCHAR2(300),
zysbjly     VARCHAR2(300),
cyrs        NUMBER(10),
yjrs        NUMBER(10),
jzbwb       VARCHAR2(80),
scjyfs      CHAR(3),
csbh_bz     CHAR(1) default 0,
gds_bz      CHAR(1),
jmgbfje     NUMBER(18,4),
zczbbz_dm   VARCHAR2(3),
frhjdz      VARCHAR2(80),
zrrtzbl     NUMBER(18,4),
wztzbl      NUMBER(18,4),
gytzbl      NUMBER(18,4),
hy_dm_yi    VARCHAR2(4),
hy_dm_er    VARCHAR2(4),
hy_dm_san   VARCHAR2(4),
ggh_bj      CHAR(1),
djzlshjg    CHAR(1),
qttzbl      NUMBER(18,4),
wcjyfs_dm   CHAR(2),
dljnlzs_bz  CHAR(1),
xmfzrdh     VARCHAR2(30),
zfjgbj      VARCHAR2(6),
zczbhgb     NUMBER(18,4)
)
tablespace USERS
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 8M
next 1M
minextents 1
maxextents unlimited
);

select tablespace_name, username, bytes, max_bytes from dba_ts_quotas;