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

最新推荐文章于 2024-06-24 08:00:00 发布

myheartjava

最新推荐文章于 2024-06-24 08:00:00 发布

阅读量1.4w

点赞数 2

文章标签：数据库

本文链接：https://blog.csdn.net/myheartjava/article/details/49735167

版权

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