IMP-00032: SQL statement exceeded buffer length_unrecognized statement in the export file-优快云博客

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

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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