oracle 11.2.0.3 expdp 时报错,ORA-39181: Only partial table data may be exported due to fine grain
来源:互联网 发布:淘宝退货折旧费怎么算 编辑:程序博客网 时间:2024/05/18 12:38
$ expdp system/system full=y directory=EXPDPIMPDP2 dumpfile=20170819_%U.dmp parallel=4 job_name=expimpdp
输出日志有不少如下信息
ORA-39181: Only partial table data may be exported due to fine grain access control on “xx”.”yy”
在mos搜索后找到如下解决方案
SOLUTION
To avoid this:
Grant the privilege EXEMPT ACCESS POLICY to the exporting user
-or-
Disable the VPD policy.
参考:
ORA-39181:Only Partial Table Data Exported Due To Fine Grain Access Control (文档 ID 422480.1)
阅读全文
0 0
- oracle 11.2.0.3 expdp 时报错,ORA-39181: Only partial table data may be exported due to fine grain
- expdp ORA-39181:Only Partial Table Data Exported Due To Fine Grain Access Control
- ORA-39181: Only partial table data may be exported due to fine grain access control on "OE"."PURCHAS
- ORA-39181:Only Partial Table Data Exported Due To Fine Grain Access Control [ID 422480.1]
- oracle 11.2.0.3 expdp 时报错,PLS-00201: identifier 'DMSYS.DBMS_DM_MODEL_EXP' must be declared
- XAMPP报错This may be due to a blocked port, missing dependencies
- This may be due to a corruption of the heap
- This may be due to a corruption of the heap!
- EXPDP导出数据时报错ORA-12154
- all to be fine
- Error "The form cannot be rendered. This may be due to a misconfiguration......"的解决方案
- 编译报错“a pointer to a bound function may only be used to call the function”的解决办法
- 创建主键时报错:ERROR 1075 (42000): Incorrect table definition; there can be only one auto column and it mus
- 创建主键时报错:ERROR 1075 (42000): Incorrect table definition; there can be only one auto column and it mus
- Use MFC in a Static Library,This may be due to a corruption of the heap....
- Hint: This may be the result of an unspecified view, due to default view name generation.)]
- XAMPP Error: Apache shutdown unexpectedly.This may be due to a blocked port, missing dependencies...
- ORA-14460: only one COMPRESS or NOCOMPRESS clause may be specified
- linux——用脚本自动安装虚拟机
- NOIP复赛复习(十)怎样才能拿到高分?
- 跟大师学习系统编程---操作系统加载(6)
- 6-16 Topological Sort(25 point(s))
- golang进阶(六)——restful开发优雅处理error
- oracle 11.2.0.3 expdp 时报错,ORA-39181: Only partial table data may be exported due to fine grain
- Java 数据 -- 集合
- 跟大师学习系统编程---操作系统加载(7)
- 实现网页布局
- NOIP复赛复习(八)STL算法与树结构模板
- Android Studio的安装与下载
- 6-1 单链表逆转(20 point(s))
- IntelliJ IDEA中怎么查看文件中所有方法(类似eclipse里面的outline)
- 任玉刚:让你的职业迷茫从哪来回哪去