錯誤: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 一新的數(shù)據(jù)庫，表空間改不是MYSPACE）

瞬間煙火

我也遇到樓住的這個問題   怎么解決阿、

dingning239

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


提示很 明確啊  ，沒有表空間'MYSPACE'

flutter

ORACLE 8/9版本吧，要求EXP/IMP的用戶為同一表空間名稱，
   比如：EXP的系統(tǒng)，用戶A默認表空間為AA，而IMP的系統(tǒng)，用戶A的默認表空間為BB，
   則會出現(xiàn)上述錯誤。
   所以，IMP前應建立MYSPACE表空間。

oract666

不建立也沒關系，導之前先建同名的表就完了