-- 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
);
后面还有一些定义的字段名什么的,但是执行上面这些就报错了
我这张表,是在别的数据库正在用的表,另外一个项目需要用到,直接搬过来,就有问题。会不会跟表空间有关系?
我刚刚查了一下,USERS的表空间占用率为95.18