导入数据库时的错误，怎么处理阿？

[baby_zhx]

还是昨天的问题，感谢大侠的帮助，得以成功，但是，又有问题出现，如下：
**********************************************************************
导入文件: EXPDAT.DMP> kurtzjs.dat

输入插入缓冲区大小（最小为 8192 ) 30720>

经由常规路径导出由EXPORT:V08.01.06创建的文件
已经完成ZHS16CGB231280字符集和ZHS16CGB231280 NCHAR 字符集中的导入
只列出导入文件的内容(yes/no)：no>

由于对象已存在, 忽略创建错误(yes/no)：no> yes

导入权限(yes/no)：yes>

导入表数据(yes/no)：yes>

导入整个导出文件(yes/no)：no> yes

. 正在将KURTZJS的对象导入到 KURTZJS
. . 正在导入表 "CHANGHAO" 12行被导入
. . 正在导入表 "EDZB1" 12行被导入
. . 正在导入表 "FAHAO" 12行被导入
. . 正在导入表 "FUHE" 13行被导入
. . 正在导入表 "GONGHAO" 12行被导入
IMP-00017: 由于 ORACLE 错误959，以下的语句失败
"CREATE TABLE "LYDATA" ("PER1" NUMBER(4, 3), "PER2" NUMBER(4, 3), "PER3" NUM"
"BER(4, 3), "PER4" NUMBER(4, 3), "PER5" NUMBER(4, 3), "PER6" NUMBER(4, 3), ""
"PER7" NUMBER(4, 3), "PER8" NUMBER(4, 3), "PER9" NUMBER(4, 3), "PER10" NUMBE"
"R(4, 3), "PER11" NUMBER(4, 3), "PER12" NUMBER(4, 3), "PER13" NUMBER(4, 3), "
""PER14" NUMBER(4, 3), "PER15" NUMBER(4, 3), "PER16" NUMBER(4, 3), "XTTIME" "
"DATE, "DATA" CLOB, "NO" NUMBER(1, 0), "RESULT" NUMBER(1, 0)) PCTFREE 10 PC"
"TUSED 40 INITRANS 1 MAXTRANS 255 LOGGING STORAGE(INITIAL 262144) TABLESPACE"
" "LY" LOB ("DATA") STORE AS (TABLESPACE "SYSTEM" ENABLE STORAGE IN ROW CHU"
"NK 8192 PCTVERSION 10 NOCACHE STORAGE(INITIAL 131072 NEXT 659357696 MINEXT"
"ENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 50 FREELISTS 1 FREELIST GROUPS 1 B"
"UFFER_POOL DEFAULT))"
IMP-00003: ORACLE 错误959出现
ORA-00959: 表空间'LY'不存在
IMP-00017: 由于 ORACLE 错误959，以下的语句失败
"CREATE TABLE "LYGUZHANG" ("PER1" NUMBER(4, 3), "PER2" NUMBER(4, 3), "PER3" "
"NUMBER(4, 3), "PER4" NUMBER(4, 3), "PER5" NUMBER(4, 3), "PER6" NUMBER(4, 3)"
", "PER7" NUMBER(4, 3), "PER8" NUMBER(4, 3), "PER9" NUMBER(4, 3), "PER10" NU"
"MBER(4, 3), "PER11" NUMBER(4, 3), "PER12" NUMBER(4, 3), "PER13" NUMBER(4, 3"
"), "PER14" NUMBER(4, 3), "PER15" NUMBER(4, 3), "PER16" NUMBER(4, 3), "XTTIM"
"E" DATE, "DATA" CLOB, "NO" NUMBER(1, 0), "RESULT" NUMBER(1, 0)) PCTFREE 10"
" PCTUSED 40 INITRANS 1 MAXTRANS 255 LOGGING STORAGE(INITIAL 262144) TABLESP"
"ACE "LY" LOB ("DATA") STORE AS (TABLESPACE "SYSTEM" ENABLE STORAGE IN ROW "
"CHUNK 8192 PCTVERSION 10 NOCACHE STORAGE(INITIAL 131072 NEXT 195346432 MIN"
"EXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 50 FREELISTS 1 FREELIST GROUPS "
"1 BUFFER_POOL DEFAULT))"
IMP-00003: ORACLE 错误959出现
ORA-00959: 表空间'LY'不存在
IMP-00017: 由于 ORACLE 错误959，以下的语句失败
"CREATE TABLE "LYMONTH" ("PER1" NUMBER(4, 3), "PER2" NUMBER(4, 3), "PER3" NU"
"MBER(4, 3), "PER4" NUMBER(4, 3), "PER5" NUMBER(4, 3), "PER6" NUMBER(4, 3), "
""PER7" NUMBER(4, 3), "PER8" NUMBER(4, 3), "PER9" NUMBER(4, 3), "PER10" NUMB"
"ER(4, 3), "PER11" NUMBER(4, 3), "PER12" NUMBER(4, 3), "PER13" NUMBER(4, 3),"
" "PER14" NUMBER(4, 3), "PER15" NUMBER(4, 3), "PER16" NUMBER(4, 3), "XTTIME""
" DATE, "DATA" CLOB, "NO" NUMBER(1, 0), "RESULT" NUMBER(1, 0)) PCTFREE 10 P"
"CTUSED 40 INITRANS 1 MAXTRANS 255 LOGGING STORAGE(INITIAL 262144) TABLESPAC"
"E "LY" LOB ("DATA") STORE AS (TABLESPACE "SYSTEM" ENABLE STORAGE IN ROW CH"
"UNK 8192 PCTVERSION 10 NOCACHE STORAGE(INITIAL 131072 NEXT 293019648 MINEX"
"TENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 50 FREELISTS 1 FREELIST GROUPS 1 "
"BUFFER_POOL DEFAULT))"
IMP-00003: ORACLE 错误959出现
ORA-00959: 表空间'LY'不存在
IMP-00017: 由于 ORACLE 错误959，以下的语句失败
"CREATE TABLE "LYYEAR" ("PER1" NUMBER(4, 3), "PER2" NUMBER(4, 3), "PER3" NUM"
"BER(4, 3), "PER4" NUMBER(4, 3), "PER5" NUMBER(4, 3), "PER6" NUMBER(4, 3), ""
"PER7" NUMBER(4, 3), "PER8" NUMBER(4, 3), "PER9" NUMBER(4, 3), "PER10" NUMBE"
"R(4, 3), "PER11" NUMBER(4, 3), "PER12" NUMBER(4, 3), "PER13" NUMBER(4, 3), "
""PER14" NUMBER(4, 3), "PER15" NUMBER(4, 3), "PER16" NUMBER(4, 3), "XTTIME" "
"DATE, "DATA" CLOB, "NO" NUMBER(1, 0), "RESULT" NUMBER(1, 0)) PCTFREE 10 PC"
"TUSED 40 INITRANS 1 MAXTRANS 255 LOGGING STORAGE(INITIAL 262144) TABLESPACE"
" "LY" LOB ("DATA") STORE AS (TABLESPACE "SYSTEM" ENABLE STORAGE IN ROW CHU"
"NK 8192 PCTVERSION 10 NOCACHE STORAGE(INITIAL 131072 NEXT 293019648 MINEXT"
"ENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 50 FREELISTS 1 FREELIST GROUPS 1 B"
"UFFER_POOL DEFAULT))"
IMP-00003: ORACLE 错误959出现
ORA-00959: 表空间'LY'不存在
. . 正在导入表 "MIS" 45682行被导入
. . 正在导入表 "MIS2" 91行被导入
. . 正在导入表 "MLOG$_CHANGHAO" 0行被导入
. . 正在导入表 "PLAN_TABLE" 2行被导入
. . 正在导入表 "POWER" 0行被导入
. . 正在导入表 "POWERH" 0行被导入
. . 正在导入表 "XB1" 0行被导入
. . 正在导入表 "XB2" 0行被导入
. . 正在导入表 "XB3" 0行被导入
. . 正在导入表 "XB4" 0行被导入
. . 正在导入表 "XB5" 0行被导入
. . 正在导入表 "XB6" 0行被导入
. . 正在导入表 "XTDATA" 0行被导入
. . 正在导入表 "XTGUZHANG" 1行被导入
IMP-00017: 由于 ORACLE 错误959，以下的语句失败
"CREATE TABLE "XTMONTH" ("PER1" NUMBER(4, 3), "PER2" NUMBER(4, 3), "PER3" NU"
"MBER(4, 3), "PER4" NUMBER(4, 3), "PER5" NUMBER(4, 3), "PER6" NUMBER(4, 3), "
""PER7" NUMBER(4, 3), "PER8" NUMBER(4, 3), "PER9" NUMBER(4, 3), "PER10" NUMB"
"ER(4, 3), "PER11" NUMBER(4, 3), "PER12" NUMBER(4, 3), "PER13" NUMBER(4, 3),"
" "PER14" NUMBER(4, 3), "PER15" NUMBER(4, 3), "PER16" NUMBER(4, 3), "XTTIME""
" DATE, "DATA" CLOB, "NO" NUMBER(1, 0), "RESULT" NUMBER(1, 0)) PCTFREE 10 P"
"CTUSED 40 INITRANS 1 MAXTRANS 255 LOGGING STORAGE(INITIAL 262144) TABLESPAC"
"E "XTDATA" LOB ("DATA") STORE AS (TABLESPACE "SYSTEM" ENABLE STORAGE IN RO"
"W CHUNK 8192 PCTVERSION 10 NOCACHE STORAGE(INITIAL 131072 NEXT 195362816 M"
"INEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 50 FREELISTS 1 FREELIST GROUP"
"S 1 BUFFER_POOL DEFAULT))"
IMP-00003: ORACLE 错误959出现
ORA-00959: 表空间'XTDATA'不存在
. . 正在导入表 "XTTEST" 1行被导入
. . 正在导入表 "XTXIANZHI" 1行被导入
IMP-00017: 由于 ORACLE 错误959，以下的语句失败
"CREATE TABLE "XTYEAR" ("PER1" NUMBER(4, 3), "PER2" NUMBER(4, 3), "PER3" NUM"
"BER(4, 3), "PER4" NUMBER(4, 3), "PER5" NUMBER(4, 3), "PER6" NUMBER(4, 3), ""
"PER7" NUMBER(4, 3), "PER8" NUMBER(4, 3), "PER9" NUMBER(4, 3), "PER10" NUMBE"
"R(4, 3), "PER11" NUMBER(4, 3), "PER12" NUMBER(4, 3), "PER13" NUMBER(4, 3), "
""PER14" NUMBER(4, 3), "PER15" NUMBER(4, 3), "PER16" NUMBER(4, 3), "XTTIME" "
"DATE, "DATA" CLOB, "NO" NUMBER(1, 0), "RESULT" NUMBER(1, 0)) PCTFREE 10 PC"
"TUSED 40 INITRANS 1 MAXTRANS 255 LOGGING STORAGE(INITIAL 262144) TABLESPACE"
" "XTDATA" LOB ("DATA") STORE AS (TABLESPACE "SYSTEM" ENABLE STORAGE IN ROW"
" CHUNK 8192 PCTVERSION 10 NOCACHE STORAGE(INITIAL 131072 NEXT 195362816 MI"
"NEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 50 FREELISTS 1 FREELIST GROUPS"
" 1 BUFFER_POOL DEFAULT))"
IMP-00003: ORACLE 错误959出现
ORA-00959: 表空间'XTDATA'不存在
. . 正在导入表 "ZBZB" 4行被导入
. . 正在导入表 "ZBZB1" 0行被导入
. . 正在导入表 "ZHXT1" 6行被导入
成功终止导入，但出现警告。

F:\>

**********************************************************************


为什么此中xtdata表最后desc看得到列名，但是表中没有数值？怎么处理，将数值也导入表中阿？

欢迎各位帮

[mycode]

出错的信息均是因为表空间不存在而带来的。
你先建好表空间LY和xtdata,重新进行imp

正在导入表 "XTDATA" 0行被导入
表示你在导出时,xtdata表中没有数据，需要重新做exp将原来xtdata中的数据取出来。

[flowerofwind]

看了一下，惨生错误是因为表空间LY不存在，不知道你怎么导出的？

[bzszp]

先建好表空间再导

[KingSunSha]

如果是按照用户导出的话，应该不会有这个问题

[swjtu95]

按用户导出的话，不会有表空间不存在的问题。

是不是你将DMP文件改坏了啊？

[hrb_qiuyb]

其实纠正起来很简单，对报错的表空间加以建立就可以了，不是dmp文件的问题

[thingsfly]

XTDATA本来就没有数据导出吧！！在DMP文件中