Oracle 数据库导入

[itk_fghy]

Oracle 数据库在导入dmp文件后，发现有些表的数据未导入，再次使用imp命令单独导入表出现如下错误，求大神帮忙看下

导入语句：imp cmsuser/xyz@cms45 file=E:\share\hhnews.dmp tables=(releaselib) fromuser=cmsuser log=E:\share\imp_releaselib.log

日志：
连接到: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

经由常规路径由 EXPORT:V10.02.01 创建的导出文件
已经完成 ZHS16GBK 字符集和 AL16UTF16 NCHAR 字符集中的导入
导入服务器使用 AL32UTF8 字符集 (可能的字符集转换)
导出客户机使用 AL32UTF8 字符集 (可能的字符集转换)
. 正在将 CMSUSER 的对象导入到 CMSUSER
IMP-00015: 由于对象已存在, 下列语句失败:
"CREATE TABLE "RELEASELIB" ("ARTICLEID" NUMBER NOT NULL ENABLE, "ORIGINALID""
" NUMBER, "INTROTITLE" VARCHAR2(800), "TITLE" VARCHAR2(1500), "SUBTITLE" VAR"
"CHAR2(800), "AUTHOR" VARCHAR2(800), "ABSTRACT" VARCHAR2(2000), "CREATETIME""
" DATE, "SOURCENAME" VARCHAR2(100), "SOURCEURL" VARCHAR2(100), "SOURCEICON" "
"VARCHAR2(200), "ATTR" NUMBER(2, 0), "PICLINKS" VARCHAR2(800), "WORDCOUNT" N"
"UMBER, "KEYWORD" VARCHAR2(400), "IMPORTANCE" NUMBER, "URL" VARCHAR2(400), ""
"PICCOUNT" NUMBER, "MULTIATTACH" VARCHAR2(800), "ISREMOTESEND" NUMBER(2, 0),"
" "IMPORTID" NUMBER, "TYPEID" NUMBER NOT NULL ENABLE, "CATEGORY" VARCHAR2(40"
"0), "AUTOCATEGORY" VARCHAR2(400), "EDITOR" VARCHAR2(40), "LIABILITY" VARCHA"
"R2(40), "PAGECOUNT" NUMBER, "COMMENTFLAG" VARCHAR2(100), "TAGS" VARCHAR2(40"
"0), "CONTENT" CLOB, "MIME" CLOB, "ORITYPEID" NUMBER, "SELECTOR" VARCHAR2(40"
"), "PROCESSOR" VARCHAR2(40), "SUBSCRIBER" VARCHAR2(40), "DISPLAYCTL" NUMBER"
"(2, 0), "BRIEFABSTRACT" VARCHAR2(800), "ARTIPOSITION" VARCHAR2(800), "PUBTI"
"ME" DATE, "TRACE" CLOB, "PREHANDLER" VARCHAR2(800), "MASTERID" NUMBER, "PUB"
"LISHSTATE" NUMBER(2, 0), "TPLID" NUMBER, "ARCHIVEFLAG" NUMBER, "INTODATACEN"
"TER" NUMBER, "INPUTER" VARCHAR2(40), "EXPIRATIONTIME" DATE, "ISTOP" NUMBER("
"1, 0), "SPECSUFFIXWORD" VARCHAR2(100), "SPECSUFFIXURL" VARCHAR2(100), "IMPO"
"RTMARK" VARCHAR2(200), "PAGETITLE" VARCHAR2(1000), "JABBARMARK" VARCHAR2(20"
"0), "FIRSTPUB" VARCHAR2(40), "COMPOSE" NUMBER(1, 0), "ISSPECIALARTICLE" NUM"
"BER(1, 0)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 8"
"38860800 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "CMS"
"TABLE" LOGGING NOCOMPRESS LOB ("CONTENT") STORE AS (TABLESPACE "CMSCLOB" D"
"ISABLE STORAGE IN ROW CHUNK 8192 PCTVERSION 10 NOCACHE LOGGING STORAGE(INI"
"TIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)) LOB ("TRACE""
") STORE AS (TABLESPACE "CMSCLOB" DISABLE STORAGE IN ROW CHUNK 8192 PCTVERS"
"ION 10 NOCACHE LOGGING STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1"
" BUFFER_POOL DEFAULT)) LOB ("MIME") STORE AS (TABLESPACE "CMSMIME" DISABLE"
" STORAGE IN ROW CHUNK 8192 PCTVERSION 10 NOCACHE LOGGING STORAGE(INITIAL 6"
"5536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT))"
IMP-00032: SQL 语句超过缓冲区长度
IMP-00008: 导出文件中出现无法识别的语句:
ANALYZE TABLE "MGMT_AGENT_SEC_INFO" ESTIMATE STATISTICS
成功终止导入, 但出现警告。

[一颗向往数据的心丶]

不是提示你对象已经存在了么

[itk_fghy]

把表删了再导 ？ 我先删除表试试看行不。 IMP-00032: SQL 语句超过缓冲区长度，这个有没有影响

[bw555]

删除releaselib 表重新导入 或 导入时增加参数 ignore=y 这样可以只导入数据

[itk_fghy]

当时用这条语句导出的：exp cmsuser/xyz file=e:\xybeifen\oracle%date:~11,3%.dmp full=y log=e:\xybeifen\oracle%date:~11,3%.log 我开始导入的时候用的用：imp cmsuser/xyz file=e:\share\hhnews.dmp full=y log=imp.log 导的过程中日志中出现找不到表空间，建了表空间后我用：imp cmsuser/xyz file=e:\share\hhnews.dmp fromuser=cmsuser touser=cmsuser ignore=y 重新导了之后就出现有些表中没有数据， 请帮忙看下，我的导入有什么问题，给个正确的导入方法 ，谢谢