UDE-31626 ORA-31626 ORA-39076报错

一、问题描述

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权限给特定用户进行业务处理，存在无法正常操作，或者相关异常。遇到该情况时，可以根据实际业务需要，直接授权特定角色给用户。