同事有用sqlldr导入数据里报了以下错误:
SQL*Loader-951: Error calling once/load initialization
ORA-00604: error occurred at recursive SQL level 1
ORA-01031: insufficient privileges
我用set events跟踪了一下导入过程,发现是缺少lock any table权限,只要给相应的导入用户加上lock any table权限就行
grant lock any table to
问题解决过程:
1.alter system set events '604 trace name ERRORSTACK level 4';
2.<让他再次执行sqlload,当然再次报错>
3.alter system set events '604 trace name ERRORSTACK off';
4.查看udump下的trace文件
作者:george.ma
blog:http://blog.chinaunix.net/u/12521/
阅读(6010) | 评论(0) | 转发(0) |