IMP-00032: SQL statement exceeded buffer length

最新推荐文章于 2021-04-07 19:47:39 发布

转载最新推荐文章于 2021-04-07 19:47:39 发布 · 2.2k 阅读

备份&还原&修复专栏收录该内容

25 篇文章

订阅专栏

在尝试将MANPOWER数据库对象导入到TEST环境时，遇到了SQL语句长度超出限制的问题，并产生了警告信息。导入操作在AL32UTF8和AL16UTF16NCHAR字符集中成功完成，但部分表如C_YMMON和相关日志表导入时出现长度过长的SQL语句错误。最终，导入以带有警告的方式终止。

imp system/password file=sys07.dmp fromuser=manpower touser=test tables=c_ymmon grants=n indexes=n

Import: Release 10.2.0.5.0 - Production on Mon Feb 17 10:21:03 2014

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

Connected to: Oracle Database 10g Release 10.2.0.5.0 - 64bit Production

Export file created by EXPORT:V10.02.01 via direct path
import done in AL32UTF8 character set and AL16UTF16 NCHAR character set
. importing MANPOWER's objects into TEST
. . importing table "C_YMMON" 1966057 rows imported
IMP-00032: SQL statement exceeded buffer length
IMP-00008: unrecognized statement in the ex¡ä¿¡æ¯)'e:
IMP-00032: SQL statement exceeded buffer length
IMP-00008: unrecognized statement in the export file:
'äººå“¡ç”Ÿç‰©ç‰¹å¾è¨˜éŒ„LOGæª”(FACE_PERDATA_LOG)'
IMP-00032: S¡è€ƒå‹¤é»žæŒ‡å®šæª”(FACE_WARESEC)'h
IMP-00032: SQL statement exceeded buffer length file:
IMP-00008: unrecognized statement in the export file:
'è€ƒå‹¤é»žèˆ‡äººè‡‰è¨å‚™é—œè¯æª”(FACE_WHERE_DEVICE)'
Import terminated successfully with warnings.

------------------------------------------------------

先确保NLS_LANG设定正确。

imp system/password file=sys07.dmp fromuser=manpower touser=test tables=c_ymmon grants=n indexes=n buffer=1000000