imp导入库表空间找不到问题记录

    从生产上导出的dmp文件，导入到测试环境上时，提示如下错误：

IMP-00017: following statement failed with ORACLE error 959:

"CREATE TABLE "TINSFILE" ("INS_OP_ID" NUMBER(10, 0) NOT NULL ENABLE, "INS_ID"

"" NUMBER(10, 0) NOT NULL ENABLE, "OIS_BIZ_TYPE" NUMBER(10, 0) NOT NULL ENAB"

"LE, "OIS_MENU_TYPE" NUMBER(10, 0) NOT NULL ENABLE, "FILE_NAME" VARCHAR2(256"

"), "FILE_CONTENT" BLOB, "REMARK" VARCHAR2(256), "USER_ID" NUMBER(10, 0) NOT"

" NULL ENABLE, "OP_DATE" NUMBER(10, 0) NOT NULL ENABLE, "OP_TIME" NUMBER(10,"

" 0) NOT NULL ENABLE) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE"

"(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 FREELISTS 1 FREELIST GROUPS 1 BUFF"

"ER_POOL DEFAULT) TABLESPACE "OTC" LOGGING NOCOMPRESS LOB ("FILE_CONTENT") S"

"TORE AS BASICFILE (TABLESPACE "OTC" ENABLE STORAGE IN ROW CHUNK 8192 RETEN"

"TION NOCACHE LOGGING STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 FREE"

"LISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT))"

IMP-00003: ORACLE error 959 encountered

ORA-00959: tablespace 'OTC' does not exist

该错误一般发生在存在BLOB字段的表上，这个TINSFILE表确实存在一个这样的字段；

SQL> alter tablespace xc_product rename to otc;

 

Tablespace altered

 

imp xc_product/1@oisdb file=./20180314AftClear.Dat fromuser=otc touser=xc_product

刚刚报错的表成功导入了；

转载于:https://www.cnblogs.com/skiing886/p/8579222.html