各位大侠,Linux服务器上的Oracle版本是2.0.1.0,并且PL/SQL Developer成功导出某一张表,但同样用PL/SQL PL/SQL Developer 导入另一台同样装有此版本的Oracle服务器上就报错,唯一区别表空间名和所创建的用户名不对。请哪位大侠帮忙解决,谢谢!导入错误:已经完成 ZHS16GBK 字符集和 AL16UTF16 NCHAR 字符集中的导入. 正在将 DATAEXCHANGE 的对象导入到 RUGAOIMP-00015: 由于对象已存在, 下列语句失败: "CREATE TABLE "QL_INF_INTER" ("QL_ID" VARCHAR2(14) NOT NULL ENABLE, "UPDATE_"
"DATE" DATE NOT NULL ENABLE, "SYNC_DATE" DATE, "SYNC_SIGN" VARCHAR2(1), "SYN"
"C_ERROR_DESC" VARCHAR2(1000), "UPDATE_TYPE" CHAR(1) NOT NULL ENABLE, "QL_KI"
"ND" CHAR(10) NOT NULL ENABLE, "QL_REG_ID" VARCHAR2(50) NOT NULL ENABLE, "QL"
"_NAME" VARCHAR2(1000) NOT NULL ENABLE, "QL_DEPID" VARCHAR2(10) NOT NULL ENA"
"BLE, "QL_DEPSTATE" CHAR(1) NOT NULL ENABLE, "ENTRUST_NAME" VARCHAR2(200), ""
"QL_STATE" CHAR(1) NOT NULL ENABLE, "BY_LAW" CLOB NOT NULL ENABLE, "START_TI"
"ME" TIMESTAMP (6) NOT NULL ENABLE, "END_TIME" TIMESTAMP (6), "PROMISE_DAY" "
"NUMBER(8, 0), "PROMISE_TYPE" VARCHAR2(2), "ANTICIPATE_DAY" NUMBER(8, 0), "A"
"NTICIPATE_TYPE" VARCHAR2(2), "OUT_FLOW_IMG" BLOB, "IN_FLOW_IMG" BLOB, "IN_F"
"LOW_INFO" CLOB, "SERVICE_GUIDE" CLOB, "SERVICE_TABLE" CLOB, "QUESTION_BY_AN"
"SWER" CLOB, "CHARGE_BASIS" CLOB, "CHARGE_FLAG" CHAR(1) NOT NULL ENABLE, "CH"
"ARGE_STANDARD" CLOB, "STANDARD" CLOB, "PUNISH_CLASS" VARCHAR2(400), "TRANSA"
"CT_URL" VARCHAR2(600), "SUPERVISE_TEL" VARCHAR2(80), "LINK_TEL" VARCHAR2(80"
"), "TRANSACT_ADDR" VARCHAR2(400), "TRANSACT_DEPNAME" VARCHAR2(400), "CONDIT"
"ION" CLOB) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 6"
"291456 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "DATAE"
"XCHANGE" LOGGING NOCOMPRESS LOB ("BY_LAW") STORE AS (TABLESPACE "DATAEXCHA"
"NGE" ENABLE STORAGE IN ROW CHUNK 8192 PCTVERSION 10 NOCACHE LOGGING STORAG"
"E(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)) LOB ("O"
"UT_FLOW_IMG") STORE AS (TABLESPACE "DATAEXCHANGE" ENABLE STORAGE IN ROW CH"
"UNK 8192 PCTVERSION 10 NOCACHE LOGGING STORAGE(INITIAL 65536 FREELISTS 1 F"
"REELIST GROUPS 1 BUFFER_POOL DEFAULT)) LOB ("IN_FLOW_IMG") STORE AS (TABLE"
"SPACE "DATAEXCHANGE" ENABLE STORAGE IN ROW CHUNK 8192 PCTVERSION 10 NOCACHE"
" LOGGING STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL D"
"EFAULT)) LOB ("IN_FLOW_INFO") STORE AS (TABLESPACE "DATAEXCHANGE" ENABLE S"
"TORAGE IN ROW CHUNK 8192 PCTVERSION 10 NOCACHE LOGGING STORAGE(INITIAL 655"
"36 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)) LOB ("SERVICE_GUIDE""
") STORE AS (TABLESPACE "DATAEXCHANGE" ENABLE STORAGE IN ROW CHUNK 8192 PCT"
"VERSION 10 NOCACHE LOGGING STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROU"
"PS 1 BUFFER_POOL DEFAULT)) LOB ("SERVICE_TABLE") STORE AS (TABLESPACE "DAT"
"AEXCHANGE" ENABLE STORAGE IN ROW CHUNK 8192 PCTVERSION 10 NOCACHE LOGGING "
"STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)) L"
"OB ("QUESTION_BY_ANSWER") STORE AS (TABLESPACE "DATAEXCHANGE" ENABLE STORA"
"GE IN ROW CHUNK 8192 PCTVERSION 10 NOCACHE LOGGING STORAGE(INITIAL 65536 F"
"REELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)) LOB ("CHARGE_BASIS") STO"
"RE AS (TABLESPACE "DATAEXCHANGE" ENABLE STORAGE IN ROW CHUNK 8192 PCTVERSI"
"ON 10 NOCACHE LOGGING STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 "
"BUFFER_POOL DEFAULT)) LOB ("CHARGE_STANDARD") STORE AS (TABLESPACE "DATAEX"
"CHANGE" ENABLE STORAGE IN ROW CHUNK 8192 PCTVERSION 10 NOCACHE LOGGING STO"
"RAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)) LOB "
"("STANDARD") STORE AS (TABLESPACE "DATAEXCHANGE" ENABLE STORAGE IN ROW CHU"
"NK 8192 PCTVERSION 10 NOCACHE LOGGING STORAGE(INITIAL 65536 FREELISTS 1 FR"
"EELIST GROUPS 1 BUFFER_POOL DEFAULT)) LOB ("CONDITION") STORE AS (TABLESPA"
"CE "DATAEXCHANGE" ENABLE STORAGE IN ROW CHUNK 8192 PCTVERSION 10 NOCACHE LO"
"GGING STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFA"
"ULT))"成功终止导入, 但出现警告。
"DATE" DATE NOT NULL ENABLE, "SYNC_DATE" DATE, "SYNC_SIGN" VARCHAR2(1), "SYN"
"C_ERROR_DESC" VARCHAR2(1000), "UPDATE_TYPE" CHAR(1) NOT NULL ENABLE, "QL_KI"
"ND" CHAR(10) NOT NULL ENABLE, "QL_REG_ID" VARCHAR2(50) NOT NULL ENABLE, "QL"
"_NAME" VARCHAR2(1000) NOT NULL ENABLE, "QL_DEPID" VARCHAR2(10) NOT NULL ENA"
"BLE, "QL_DEPSTATE" CHAR(1) NOT NULL ENABLE, "ENTRUST_NAME" VARCHAR2(200), ""
"QL_STATE" CHAR(1) NOT NULL ENABLE, "BY_LAW" CLOB NOT NULL ENABLE, "START_TI"
"ME" TIMESTAMP (6) NOT NULL ENABLE, "END_TIME" TIMESTAMP (6), "PROMISE_DAY" "
"NUMBER(8, 0), "PROMISE_TYPE" VARCHAR2(2), "ANTICIPATE_DAY" NUMBER(8, 0), "A"
"NTICIPATE_TYPE" VARCHAR2(2), "OUT_FLOW_IMG" BLOB, "IN_FLOW_IMG" BLOB, "IN_F"
"LOW_INFO" CLOB, "SERVICE_GUIDE" CLOB, "SERVICE_TABLE" CLOB, "QUESTION_BY_AN"
"SWER" CLOB, "CHARGE_BASIS" CLOB, "CHARGE_FLAG" CHAR(1) NOT NULL ENABLE, "CH"
"ARGE_STANDARD" CLOB, "STANDARD" CLOB, "PUNISH_CLASS" VARCHAR2(400), "TRANSA"
"CT_URL" VARCHAR2(600), "SUPERVISE_TEL" VARCHAR2(80), "LINK_TEL" VARCHAR2(80"
"), "TRANSACT_ADDR" VARCHAR2(400), "TRANSACT_DEPNAME" VARCHAR2(400), "CONDIT"
"ION" CLOB) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 6"
"291456 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "DATAE"
"XCHANGE" LOGGING NOCOMPRESS LOB ("BY_LAW") STORE AS (TABLESPACE "DATAEXCHA"
"NGE" ENABLE STORAGE IN ROW CHUNK 8192 PCTVERSION 10 NOCACHE LOGGING STORAG"
"E(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)) LOB ("O"
"UT_FLOW_IMG") STORE AS (TABLESPACE "DATAEXCHANGE" ENABLE STORAGE IN ROW CH"
"UNK 8192 PCTVERSION 10 NOCACHE LOGGING STORAGE(INITIAL 65536 FREELISTS 1 F"
"REELIST GROUPS 1 BUFFER_POOL DEFAULT)) LOB ("IN_FLOW_IMG") STORE AS (TABLE"
"SPACE "DATAEXCHANGE" ENABLE STORAGE IN ROW CHUNK 8192 PCTVERSION 10 NOCACHE"
" LOGGING STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL D"
"EFAULT)) LOB ("IN_FLOW_INFO") STORE AS (TABLESPACE "DATAEXCHANGE" ENABLE S"
"TORAGE IN ROW CHUNK 8192 PCTVERSION 10 NOCACHE LOGGING STORAGE(INITIAL 655"
"36 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)) LOB ("SERVICE_GUIDE""
") STORE AS (TABLESPACE "DATAEXCHANGE" ENABLE STORAGE IN ROW CHUNK 8192 PCT"
"VERSION 10 NOCACHE LOGGING STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROU"
"PS 1 BUFFER_POOL DEFAULT)) LOB ("SERVICE_TABLE") STORE AS (TABLESPACE "DAT"
"AEXCHANGE" ENABLE STORAGE IN ROW CHUNK 8192 PCTVERSION 10 NOCACHE LOGGING "
"STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)) L"
"OB ("QUESTION_BY_ANSWER") STORE AS (TABLESPACE "DATAEXCHANGE" ENABLE STORA"
"GE IN ROW CHUNK 8192 PCTVERSION 10 NOCACHE LOGGING STORAGE(INITIAL 65536 F"
"REELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)) LOB ("CHARGE_BASIS") STO"
"RE AS (TABLESPACE "DATAEXCHANGE" ENABLE STORAGE IN ROW CHUNK 8192 PCTVERSI"
"ON 10 NOCACHE LOGGING STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 "
"BUFFER_POOL DEFAULT)) LOB ("CHARGE_STANDARD") STORE AS (TABLESPACE "DATAEX"
"CHANGE" ENABLE STORAGE IN ROW CHUNK 8192 PCTVERSION 10 NOCACHE LOGGING STO"
"RAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)) LOB "
"("STANDARD") STORE AS (TABLESPACE "DATAEXCHANGE" ENABLE STORAGE IN ROW CHU"
"NK 8192 PCTVERSION 10 NOCACHE LOGGING STORAGE(INITIAL 65536 FREELISTS 1 FR"
"EELIST GROUPS 1 BUFFER_POOL DEFAULT)) LOB ("CONDITION") STORE AS (TABLESPA"
"CE "DATAEXCHANGE" ENABLE STORAGE IN ROW CHUNK 8192 PCTVERSION 10 NOCACHE LO"
"GGING STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFA"
"ULT))"成功终止导入, 但出现警告。
Linux下10G以上建议用expdp导出,用impdp导入。
IMP-00015: 由于对象已存在,导入导出的时候要对应。 可以加 ingore=y 参数试试.