各位大侠,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))"成功终止导入, 但出现警告。
解决方案 »
- sql文件导入后,中文变乱码,怎样解决?
- 超奇怪的问题,包不能编译通过
- 下面的查询怎样修改来提高执行效率?
- 请问VC如何调用并执行SQL的脚本呢??
- 这个创建表的SQL语句在Oracle为什么不能执行?
- Oracle9i中,要判断一个表是否存在,如果存在,就删除此表重新建立,没有就不删除重建,SQL该如何写?
- 有关日期的select语句
- 菜鸟提问,请问sysman,system,sys,internal这些用户用来做什么,权限怎样!
- 请问java怎么调用存储函数?
- 访问ORA非常的慢,如何优化
- 求一存储过程
- oracle触发器 调用一个JAVA程序。如何将这个JAVA程序用到的多个(N个)外部JAR引入到Oracle里面
Linux下10G以上建议用expdp导出,用impdp导入。
IMP-00015: 由于对象已存在,导入导出的时候要对应。 可以加 ingore=y 参数试试.