datapump 导出数据时无法创建job ORA-31626,ORA-31633,ORA-01031
来源:互联网 发布:打扮家 知乎 编辑:程序博客网 时间:2024/05/01 21:00
今天expdp导出数据遇到这样的报错
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
参考oracle官方文档 ID 351598.1
Solution: grant the CREATE TABLE privilege to the user that runs the export (scott) or grant it to the role (expdp_role) that is granted to the user that runs the export, e.g.:
GRANT create table TO scott;
-- or:
GRANT create table TO expdp_role;
-- or:
GRANT create table TO expdp_role;
Alternatively, run the export with a different privileged user that has the 'CREATE TABLE' privilege, e.g.: run the export while connecting with the SYSTEM schema.
0 0
- datapump 导出数据时无法创建job ORA-31626,ORA-31633,ORA-01031
- ORA-31623 When Submitting a Datapump Job [ID 308388.1]
- 创建JOB时ORA-01008的处理
- ORA-31693, ORA-02354 and ORA-01555 with Export Datapump
- ORA
- ora
- ORA-01466: 无法读取数据
- DataPump 导入时报错 ORA-39125
- ORA-09817&ORA-01031
- ORA-01031与存储过程和JOB
- 执行job时出现错误ORA-08102
- ORA-31693, ORA-02354 and ORA-01555 with Export Datapump (Doc ID 1580798.1)
- 无法创建磁盘数据库报错ora-01031 insufficient privileges
- EXPDP导出数据时报错ORA-12154
- 数据泵导出报ORA-31617错误
- ORA-28368: 无法自动创建 wallet
- ORA-28368: 无法自动创建 wallet
- ORA-17629 ORA-17627 ORA-01031
- oracle 11g dataguard 升级为maximize protection
- Android Fragment 真正的完全解析(上)
- AbstractMap
- Qt,Qt Creator,minGW,VS关系
- 服务器启动的时候,如何加载spring?
- datapump 导出数据时无法创建job ORA-31626,ORA-31633,ORA-01031
- SVN服务器搭建和使用(三)
- Kafka源码深度解析-序列10 -Server入门-Zookeeper与集群管理原理
- Spring学习之SpringMVC框架快速搭建实现用户登录功能
- MYSQL数据库CMD命令笔记整理
- OC中的富文本
- 被说了很多遍的设计模式---原型模式
- go time 包操作数据库
- HBase 常用Shell命令