SQL*Loader-3120
sqlldr中启用挂起、恢复功能，即设置resumable=y，可能出现如下错误：
SQL*Loader-3120: Resumable parameters ignored -- current session not resumable
ORA-01031: insufficient privileges
解决办法：
grant resumable to username;
官方文档描述：
Oracle Database Administrator's Guide 10g Release 2 (10.2) B14231-02
page: 14-11
Because suspended statements can hold up some system resources, users must be granted the RESUMABLE system privilege before they are allowed to enable resumable space allocation and execute resumable statements.
SQL*Loader-3120: Resumable parameters ignored -- current session not resumable
ORA-01031: insufficient privileges
解决办法：
grant resumable to username;
官方文档描述：
Oracle Database Administrator's Guide 10g Release 2 (10.2) B14231-02
page: 14-11
Because suspended statements can hold up some system resources, users must be granted the RESUMABLE system privilege before they are allowed to enable resumable space allocation and execute resumable statements.
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/7417681/viewspace-714022/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
最新文章
- 区分exp&expdp导出的dmp文件
- ORA-27300、ORA-27301、ORA-27302、ORA-27303
- 字段 与 变量 同名造成的sql问题
- Configuring the Reserved Pool
- char, varchar2, nchar, nvarchar2
- ORA-39714: upgrade script utlmmig.sql failed
- Archive log rejected (thread 1 sequence 2200) at host 'standby'
- 数据文件offline后unusable索引造成的问题
- 物理备库open ORA-10458
- lsnrctl start - Linux Error 29 Illegal seek
