Scenario:

A full database export using both conventional export utility and datapump has so many errors and warnings in their log file.

Conventional Export log

EXP-00008: ORACLE error 6550 encountered
ORA-06550: line 1, column 14:
PLS-00201: identifier ‘EXFSYS.DBMS_EXPFIL_DEPASEXP’ must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
EXP-00083: The previous problem occurred when calling EXFSYS.DBMS_EXPFIL_DEPASEXP.schema_info_exp

Datapump Export log

ORA-39127: unexpected error from call to “EXFSYS”.”DBMS_EXPFIL_DEPASEXP”.”SYSTEM_INFO_EXP”
ORA-44002: invalid object name
ORA-06512: at “SYS.DBMS_ASSERT”, line 316
ORA-06512: at “SYS.DBMS_METADATA”, line 9263
Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/PRE_SYSTEM_ACTIONS/PROCACT_SYSTEM
Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/PROCOBJ
ORA-39127: unexpected error from call to “EXFSYS”.”DBMS_EXPFIL_DEPASEXP”.”SYSTEM_INFO_EXP”
ORA-44002: invalid object name
ORA-06512: at “SYS.DBMS_ASSERT”, line 316

Reason: 

EXFSYS schema is missing in the database. To install the EXFSYS schema execute the script “catexf.sql” as SYS user.

Solution:

Restart the export now. There would not be similar errors.

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/

Joel Perez’s LinkedIn: www.linkedin.com/in/SirDBaaSJoelPerez

Anuradha’s LinkedIn: https://www.linkedin.com/in/dbaanuradhamudgal/

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp

Leave a Reply