oracle IMP-00015: 由于对象已存在, 下列语句失败-优快云博客

本文链接：https://blog.youkuaiyun.com/hailingling/article/details/84675949

本文记录了在使用Oracle数据库时遇到的问题：当尝试通过IMP命令导入数据时，因为目标表已经存在而导致导入失败。文章提供了错误信息的具体内容，并展示了通过添加IGNORE参数成功解决问题的方法。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

C:\Users\Administrator>IMP DB_1011/DB_1011@DSDB FILE=D:\db\web客户端的研发\chenj\20141015-qlh.dmp FULL=Y

IMP-00015: 由于对象已存在, 下列语句失败:
"CREATE TABLE "T_COMMON_THPZ" ("THPZBH" NUMBER(19, 0) NOT NULL ENABLE, "IP" "
"VARCHAR2(30 CHAR) NOT NULL ENABLE, "CJSJ" TIMESTAMP (6), "BZ" VARCHAR2(255 "
"CHAR), "TH" VARCHAR2(255 CHAR) NOT NULL ENABLE, "GXSJ" TIMESTAMP (6), "SFYX"
"" NUMBER(1, 0)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INIT"
"IAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) "
" LOGGING NOCOMPRESS"
IMP-00015: 由于对象已存在, 下列语句失败:
"CREATE TABLE "T_COMMON_TXJD" ("BH" NUMBER(19, 0) NOT NULL ENABLE, "SSYWSJBH"
"" NUMBER(19, 0), "SSYWSJLX" VARCHAR2(50 CHAR), "CJSJ" TIMESTAMP (6), "TXMC""
" VARCHAR2(300 CHAR), "TXJDID" NUMBER(19, 0), "JDMC" VARCHAR2(150 CHAR), "LX"
"BM" VARCHAR2(50 CHAR), "GXSJ" TIMESTAMP (6)) PCTFREE 10 PCTUSED 40 INITRAN"
"S 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER"
"_POOL DEFAULT) LOGGING NOCOMPRESS"
IMP-00015: 由于对象已存在, 下列语句失败:
"CREATE TABLE "T_COMMON_TXJDYWGX" ("BH" NUMBER(19, 0) NOT NULL ENABLE, "CJSJ"
"" TIMESTAMP (6), "YWSJ" NUMBER(19, 0), "GXSJ" TIMESTAMP (6), "TXJDBH" NUMBE"
"R(19, 0)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65"
"536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) L"
"OGGING NOCOMPRESS"

修改后:
C:\Users\Administrator>IMP DB_1011/DB_1011@DSDB FILE=D:\db\web客户端的研发\chenj\20141015-qlh.dmp FULL=Y ignore=y