to: wfeng7907(无风)imp system/ST@ICARE fromuser=icare file=icare.dmp buffer=64000 commit=y log=icare_err_imp.log
IMP-00020 long column too large for column buffer size (number) Cause The column buffer is too small. This usually occurs when importing LONG data. Action Increase the insert buffer size 10,000 bytes at a time (for example). Use this step-by-step approach because a buffer size that is too large may cause a similar problem. 应该 是 buffer的问题,修改几个值试一下!!
to: wfeng7907(无风) 我用同样的语句可以把数据库导到另外一台服务器里面去,为什么这台会报这样一个错呢???
Action Increase the insert buffer size 10,000 bytes at a time (for example). Use this step-by-step approach because a buffer size that is too large may cause a similar problem.
应该 是 buffer的问题,修改几个值试一下!!
我用同样的语句可以把数据库导到另外一台服务器里面去,为什么这台会报这样一个错呢???
为何还原数据库用了将近两个小时的时间 另一配置为AMD64位/1G内在,还原一样的数据库也用了40多分钟,是不是我的语句本身有问题。