imp oracle 已存在,见鬼了，imp导入报对象已存在，但明明就没有啊

C:\Users\mrg>sqlplus XXX/XXX@XXX

SQL*Plus: Release 11.2.0.1.0 Production on 星期五 8月 3 18:47:14 2012

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

连接到:

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production

With the Partitioning, OLAP and Data Mining options

SQL> select * from user_objects where object_name like '%EXPERT%';

未选定行

SQL> exit

从 Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production

With the Partitioning, OLAP and Data Mining options 断开

C:\Users\mrg>imp XXX/XXX@XXX file=jlbzj.dmp log=imp.log tables=expert

Import: Release 11.2.0.1.0 - Production on 星期五 8月 3 18:47:33 2012

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

连接到: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Produc

tion

With the Partitioning, OLAP and Data Mining options

经由常规路径由 EXPORT:V11.02.00 创建的导出文件

已经完成 ZHS16GBK 字符集和 AL16UTF16 NCHAR 字符集中的导入

. 正在将 XXX 的对象导入到 XXX

. 正在将 XXX 的对象导入到 XXX

IMP-00015: 由于对象已存在, 下列语句失败: "CREATE TABLE "EXPERT" ("EXPERT_ID" NUMBER NOT NULL ENABLE, "PERSON_NAME" VA"

"RCHAR2(50), "SEX" VARCHAR2(100), "NATIONALITY" VARCHAR2(100), "BORN_ADDRESS"

"" VARCHAR2(100), "BIRTHDAY" DATE, "ID_TYPE" VARCHAR2(100), "ID_CARD" VARCHA"

"R2(50), "IS_BACK" VARCHAR2(100), "BACK_YEAR" VARCHAR2(4), "EMAIL" VARCHAR2("

"100), "MOBILE" VARCHAR2(50), "EDUCATED_LEVEL" VARCHAR2(100), "DEGREE" VARCH"

"AR2(100), "GRADUATION_SCHOOL" VARCHAR2(100), "GRADUATION_DATE" DATE, "PARTY"

"_NAME" VARCHAR2(100), "SPECIALTY" VARCHAR2(500), "COMPANY_ID" NUMBER, "COMP"

"ANY_NAME" VARCHAR2(100), "COMPANY2_ID" NUMBER, "ADDRESS" VARCHAR2(100), "PO"

"STCODE" VARCHAR2(20), "TEL" VARCHAR2(50), "FAX" VARCHAR2(30), "JOB_TITLE" V"

"ARCHAR2(200), "TECHNICAL_TITLE" VARCHAR2(100), "SUBJECT" VARCHAR2(100), "BE"

"GIN_DATE" DATE, "END_DATE" DATE, "CONTRIBUTION" VARCHAR2(400), "GLORY_INFO""

" VARCHAR2(1000), "IS_ACADEMICIAN" VARCHAR2(100), "IS_DOCTOR" VARCHAR2(100),"

" "IS_JUDGE" VARCHAR2(100), "LAB" VARCHAR2(100), "FUND" VARCHAR2(1000), "HON"

"OR" VARCHAR2(1000), "RESEARCH_YEARS" VARCHAR2(20), "RESEARCH_DIR" VARCHAR2("

"300), "SPECIALTY_TYPE" VARCHAR2(100), "IS_LEADER" VARCHAR2(100), "SUBJECT2""

" VARCHAR2(100), "SUBJECT3" VARCHAR2(100), "SUBJECT4" VARCHAR2(100), "FAMILY"

"_TEL" VARCHAR2(50), "FAMILY_ADDRESS" VARCHAR2(100), "FAMILY_POSTCODE" VARCH"

"AR2(50), "SECRETARY_NAME" VARCHAR2(50), "SECRETARY_EMAIL" VARCHAR2(50), "SE"

"CRETARY_TEL" VARCHAR2(30), "PARTTIME_JOB" VARCHAR2(2000), "BE_REFER" CLOB, "

""UPDATE_TIME" DATE, "UNITELECTSTATE" NUMBER, "ACHIEVEMENT" CLOB, "IS_WEB" V"

"ARCHAR2(100), "SPECIALTY_EDU" VARCHAR2(100), "EXPERT_NO" VARCHAR2(100), "ST"

"ATUS" VARCHAR2(100), "PWD" VARCHAR2(100), "IS_ONLINE" VARCHAR2(100), "IS_VA"

"LID" VARCHAR2(100), "CENTER_ID" NUMBER, "IN_YEAR" VARCHAR2(100), "RESEARCH_"

"DIR_BACKUP" VARCHAR2(300), "INFO_SOURCE" VARCHAR2(100), "REJECT_REASON" VAR"

"CHAR2(1000), "COMPANY2_FLAG" VARCHAR2(100), "THREE_TIMES_TAG" NUMBER, "ONE_"

"TIMES_TAG" NUMBER, "LAST_SELECTED_YEAR" DATE, "UNIT_FREE_TAG" NUMBER, "JUDG"

"E_GROUP_ID" VARCHAR2(6), "BELONG_SUBJECT" VARCHAR2(100), "BELONG_LEVEL" NUM"

"BER, "SELECT_WEIGHT" NUMBER, "IS_RECHOISE" NUMBER, "JUDGE_SYS_USERNAME" VAR"

"CHAR2(100), "JUDGE_SYS_PWD" VARCHAR2(100), "JUDGE_FLAG" NUMBER, "FLAG_2011""

" VARCHAR2(100), "AVOID_FLAG" VARCHAR2(10))  PCTFREE 10 PCTUSED 40 INITRANS "

"1 MAXTRANS 255 STORAGE(INITIAL 41943040 NEXT 8192 MINEXTENTS 1 FREELISTS 1 "

"FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "KWJLB" LOGGING NOCOMPRES"

"S LOB ("BE_REFER") STORE AS BASICFILE  (TABLESPACE "KWJLB" ENABLE STORAGE I"

"N ROW CHUNK 8192 PCTVERSION 10 NOCACHE LOGGING  STORAGE(INITIAL 65536 NEXT "

"1048576 MINEXTENTS 1 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)) LO"

"B ("ACHIEVEMENT") STORE AS BASICFILE  (TABLESPACE "KWJLB" ENABLE STORAGE IN"

" ROW CHUNK 8192 PCTVERSION 10 NOCACHE LOGGING  STORAGE(INITIAL 65536 NEXT 1"

"048576 MINEXTENTS 1 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT))"

成功终止导入, 但出现警告。

C:\Users\mrg>