Oracle Data Pump 工具系列：Data Pump 权限配置相关错误及解决办法汇总

与 Data Pump 权限相关的错误及解决办法：


示例语句：
> expdp scott/tiger DIRECTORY=my_dir DUMPFILE=exp_s.dmp \ 
LOGFILE=exp_s.log SCHEMAS=scott


错误1：
UDE-00008: operation generated ORACLE error 1045 
ORA-01045: user SCOTT lacks CREATE SESSION privilege; logon denied


解决方案： 授予运行该 export 作业的用户 CREATE SESSION 权限，或者授予运行该 export job 的用户所授予的 expdp_role 角色 CREATE SESSION 权限：
 
GRANT create session TO scott; 
-- or: 
GRANT create session TO expdp_role;


错误2：Master table 相关


ORA-31626: job does not exist 
ORA-31633: unable to create master table "SCOTT.SYS_EXPORT_SCHEMA_01" 
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95 
ORA-06512: at "SYS.KUPV$FT", line 863 
ORA-01031: insufficient privileges


解决方案：
GRANT create table TO scott; 
-- or: 
GRANT create table TO expdp_role;


错误3：Directory 相关


ORA-39002: invalid operation 
ORA-39070: Unable to open the log file. 
ORA-39087: directory name MY_DIR is invalid
 
ORA-39001: invalid argument value 
ORA-39000: bad dump file specification 
ORA-39087: directory name MY_DIR is invalid
 
ORA-39002: invalid operation 
ORA-39070: Unable to open the log file. 
ORA-31631: privileges are required
 
ORA-39001: invalid argument value 
ORA-39000: bad dump file specification 
ORA-31631: privileges are required


解决方案：
GRANT read, write ON DIRECTORY my_dir TO scott; 
-- or: 
GRANT read, write ON DIRECTORY my_dir TO expdp_role;


注意：如果在授予上述权限后错误重现，则磁盘上的目录可能是在 directory 对象创建后创建的，
这时需要先在数据库中 drop 该 directory 对象，确保 Oracle 数据库所安装的服务器文件系统上已存在该目录
然后再数据库中重建该 directory 对象，然后再按照上述方法授予读写权限。




错误4：表空间配额相关


ORA-31626: job does not exist
ORA-31633: unable to create master table "SCOTT.SYS_EXPORT_SCHEMA_01"
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPV$FT", line 863
ORA-01536: space quota exceeded for tablespace 'USERS'
 
ORA-31626: job does not exist
ORA-31633: unable to create master t