一、问题描述
1.操作步骤
当使用expdp对数据库进行逻辑备份:expdp tpcds/tpcds directory=dump SCHEMAS=tpcds dumpfile=tpcds_1T_oracle_%U.dmp logfile=tpcds_expdp.log cluster=n filesize=50g parallel=8
2.报错如下:
UDE-31626: operation generated ORACLE error 31626
ORA-31626: job does not exist
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79
ORA-06512: at "SYS.DBMS_DATAPUMP", line 4752
ORA-39076: cannot delete job SYS_EXPORT_SCHEMA_04 for user TPCDS
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.DBMS_DATAPUMP", line 2117
ORA-06512: at "SYS.DBMS_DATAPUMP", line 4680
ORA-06512: at "SYS.DBMS_DATAPUMP", line 6104
ORA-06512: at line 1
二、问题处理
grant create session, create table, create procedure, exp_full_database, imp_full_database to tpcds;
备注:有些时候赋予DBA权限给特定用户进行业务处理,存在无法正常操作,或者相关异常。遇到该情况时,可以根据实际业务需要,直接授权特定角色给用户。