导入数据时出错

[yzg207]

IMP-00017: following statement failed with ORACLE error 1658:
"CREATE TABLE "TJZW" ("FTID" VARCHAR2(10) NOT NULL, "SWH" NUMBER(3, 0), "CI"
"D" VARCHAR2(10), "CZ" VARCHAR2(10), "YZ" VARCHAR2(1), "CH" VARCHAR2(8), "ZI"
"Z" NUMBER(5, 1), "HC" NUMBER(3, 1), "ZAZ" NUMBER(4, 0), "DZH" VARCHAR2(3), "
""DZM" VARCHAR2(10), "DJ" VARCHAR2(1), "PM" VARCHAR2(20), "SHR" VARCHAR2(30)"
", "FZH" VARCHAR2(3), "FZM" VARCHAR2(10), "PB" NUMBER(4, 0), "JSL" VARCHAR2("
"20), "DDCC" VARCHAR2(10), "DDRQ" DATE, "DDSJ" VARCHAR2(5), "CZBZ" VARCHAR2("
"1), "YFBZ" VARCHAR2(1), "FXH" VARCHAR2(3), "PPLX" CHAR(1) DEFAULT '*' , "CZ"
"JM" VARCHAR2(2), "CZLB" VARCHAR2(1), "DFJ" VARCHAR2(2), "ZDZH" VARCHAR2(3),"
" "KZBZ" CHAR(1) DEFAULT 1 NOT NULL, "ZLBZ" CHAR(1) DEFAULT 0 "
" NOT NULL, "JYBZ" CHAR(1) DEFAULT 0 NOT NULL, "HSBZ" CHAR(1)"
" DEFAULT 0 NOT NULL, "BQBZ" CHAR(1) DEFAULT 0 NOT NULL,"
" "QTBZ" CHAR(1) DEFAULT 0 NOT NULL, "FYYM" VARCHAR2(3), "SFH" VAR"
"CHAR2(20), "HPH" VARCHAR2(32)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 2"
"55 STORAGE(INITIAL 83978240 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 64 PCTINCR"
"EASE 0 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "XCGL""
IMP-00003: ORACLE error 1658 encountered
ORA-01658: unable to create INITIAL extent for segment in tablespace XCGL
谢谢了

[maaw]

表空间不够

[yzg207]

我用下列命令后就报错，增加不了表空间。
alter tablespace xcgl add datafile '/dbf/xcgl2.dbf' size 100M;
alter tablespace xcgl add datafile '/dbf/xcgl2.dbf' size 100M
*
ERROR at line 1:
ORA-01119: error in creating database file '/dbf/xcgl2.dbf'
ORA-07352: sfccf: create error, unable to create file.
DEC OSF/1 (AXP) Error: 13: Permission denied

[maaw]

是不是你磁盘满了呢?

[yzg207]

没有满还有45%的空间没有用呢

[xiaoxiao1984]

确认当前用户可以创建'/dbf/xcgl2.dbf'的权限
确认/dbf/目录下不存在同名文件

[yzg207]

system用户应该可以创建该目录吧，我可以确认/dbf/目录下不存在同名文件

[maaw]

目录是否有写权限?

[yzg207]

看到的目录是：
drwxr-xr-x 4 root system 8192 aug 11 /dbf
是不是有权限呀