错误:IMP-00017: following statement failed 怎么解决?

z-fh

错误:IMP-00017: following statement failed 怎么解决?
IMP-00017: following statement failed with ORACLE error 959:
"CREATE TABLE "TGRADUATEPHOTO" ("TGPKSBH" VARCHAR2(20) NOT NULL ENABLE, "TGP"
"ISOLD" VARCHAR2(1), "TGPOLD" BLOB, "TGPISPHOTO" VARCHAR2(1), "TGPPHOTO" BLO"
"B, "TGPDATE" DATE, "TGPACNTNO" VARCHAR2(4) NOT NULL ENABLE) PCTFREE 10 PCT"
"USED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST "
"GROUPS 1) TABLESPACE "MYSPACE" LOGGING NOCOMPRESS LOB ("TGPOLD") STORE AS "
"(TABLESPACE "MYSPACE" ENABLE STORAGE IN ROW CHUNK 8192 PCTVERSION 10 NOCACH"
"E STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1)) LOB ("TGPPHOTO") S"
"TORE AS (TABLESPACE "MYSPACE" ENABLE STORAGE IN ROW CHUNK 8192 PCTVERSION "
"10 NOCACHE STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1))"
IMP-00003: ORACLE error 959 encountered
ORA-00959: tablespace 'MYSPACE' does not exist
. . importing table "TGRADUATEREGCHARGE" 141 rows imported
. . importing table "TGRADUATEREGCHARGEITEM" 11 rows imported
. . importing table "TGRADUATEREGCHARGEITEMDETAIL" 33 rows imported

exp 导出没问题. 也不是 MYSPACE 空间的问题（我是在用户属于 MYSPACE 的表空间exp导出,然后imp 一新的数据库，表空间改不是MYSPACE）

瞬间烟火

我也遇到楼住的这个问题   怎么解决阿、

dingning239

IMP-00003: ORACLE error 959 encountered
ORA-00959: tablespace 'MYSPACE' does not exist


提示很 明确啊  ，没有表空间'MYSPACE'

flutter

ORACLE 8/9版本吧，要求EXP/IMP的用户为同一表空间名称，
   比如：EXP的系统，用户A默认表空间为AA，而IMP的系统，用户A的默认表空间为BB，
   则会出现上述错误。
   所以，IMP前应建立MYSPACE表空间。

oract666

不建立也没关系，导之前先建同名的表就完了