oracle imp老是已存在,oracle IMP-00015: 因为对象已存在, 下列语句失败

oracle IMP-00015: 由于对象已存在, 下列语句失败

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