imp导入数据的时候报:
. . importing table "XX_XSYSREGISTER" 1 rows imported
IMP-00032: SQL statement exceeded buffer length
IMP-00008: unrecognized statement in the export file:
'???????
user_id,???iufo_userinfo?user_id???
role_id???iufo_role??role_id??
primary key?(user_id,role_id)
'
About to enable constraints...
Import terminated successfully with warnings.
查看网上的资料说需要加大buffer,可以指定buffer的大小:
例如:imp userid=user/pass file=aaa.dmp buffer=21971520
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/312079/viewspace-245816/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/312079/viewspace-245816/