EXFSYS.DBMS_EXPFIL_DEPASEXP error duing expdp

  • A+
Categories:Oracle

Today our guy got a PLS-00201 error during the schema-level expdp task, and I searched the Oracle Support website but could not find extract answer, then found a similar webpage through Baidu.
http://wenku.baidu.com/link?url=U9HC44tu6RpjDbl8bu7hRZzM71QyHCvqneW4_eNmcN-rBUQNKbflReJy0Cm8F6hrlhA2_YZ6btHeo1k8Xgcm11jsxYqtkLAgTxEmESsjkpu
Our error screen shot:
EXFSYS.DBMS_EXPFIL_DEPASEXP error duing expdp

Then I found similar methods to resolve such issues in the Oracle Support website:
How To Install/Uninstall Expression Filter Feature or EXFSYS schema along with Rules Manager (文档 ID 258618.1)
Please note this section:

The following is a list of the public synonyms that may remain after just running CATNOEXF.SQL and these would be dropped by running one of the above scripts.

And this one:
Export Full Fails With Error EXP-00083 With Reference To XDB.DBMS_XDBUTIL_INT.system_info_exp After A Successful Deinstallation of XDB (文档 ID 1461971.1)
Please note this part:

Another similar issue:
Expdp Fails With PLS-00201: Identifier 'Dmsys.Dbms_dm_model_exp' Must Be Declared (文档 ID 1243504.1)

From the above notes, I decided to do following steps to fix this issue:
1. Check if the user EXFSYS had been removed
2. Check if any synonyms of EXFSYS was left
3. Check if the table SYS.EXPPKGACT$ had some rows relating with the EXFSYS
4. Export the data again to check if the issue was resolved

EXFSYS.DBMS_EXPFIL_DEPASEXP error duing expdp
EXFSYS.DBMS_EXPFIL_DEPASEXP error duing expdp
Done.

Sentences were used:

Comment

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen: