expdp遭遇ORA-39006、ORA-39065、ORA-01403、ORA-39097错误

2014-11-24 18:40:59 · 作者: · 浏览: 0

今天使用expdp数据泵导出数据时报错了。


虽然不像网上其他人碰到的还出现ORA-00600的错误,但是照着网上的做法,重新生成一些 DATAPUMP API用到的视图问题就解决了:


可以参考一下Metalink上的文章:




In this Document
Symptoms
Cause
Solution
References





d) Environment variables have been reviewed against Note 351650.1
but are considered to be valid.


As the SYSDBA user, please run the following scripts :-


Then reattempt the running of EXPDP

This article is created based on observations and actions of two notes :


For this Data Pump export issue, it is required to run BOTH scripts.