An Oracle EXP Export error Resolution (reproduced)

Some time ago, a Shanghai insurance customer IT director called, said their developers in the development environment to execute exp error, let me go over to check. The spirit of "customer-oriented, service for the root" purpose, the first time to the customer site.

and customer developers to view the details of exp error:

Exporting Pre-schema process objects and operations EXP-00008: Encountering ORACLE error 4063 Ora-04063:package Body "Dmsys. Dbms_dm_imp_internal "has errors Ora-06508:pl/sql:could not the Find program unit being called: "Dmsys. Dbms_dm_imp_internal " Ora-06512:at "Dmsys. Dbms_dm_model_exp ", line 303 Ora-06512:at Line 1 EXP-00083: Call Dmsys. Dbms_dm_model_exp.schema_info_exp A previous problem occurred

The first time suspect is not because the Dmsys user below the Dbms_dm_imp_internal object Invalid result exp error, through PL/SQL develop connected to the database, view the object, the results confirmed my guess.

The Dmsys user has a partially compiled package that contains the dbms_dm_imp_internal of the exp operation, (as to why the system has failed to compile the package, they are not sure what the cause is, And now it can't be traced. The package under which the system Dmsys (which is used by the data mining component) is encrypted and cannot be recompiled. I tried it down and the compilation was unsuccessful.

Solution: Rebuild after user delete

To delete a Dmsys User:

Sql>drop user Dmsys Cascade;

User rebuild: Rebuild the user with the following script

Sql>@?/rdbms/admin/dminst.sql

After the user has been built, sure enough the user below all the package objects are valid, so let developers test exp export, tragedy continues to occur, the original error resolved, but a new error occurred:

Exp-00008:oracle Error 4063 encountered Ora-04063:package Body "Exfsys. Dbms_expfil_exp "has errors Ora-06508:pl/sql:could not the Find program unit being called: "Exfsys. Dbms_expfil_exp " Ora-06512:at "Exfsys. Dbms_expfil_depasexp ", line 61 Ora-06512:at Line 1 Exp-00083:the previous problem occurred when calling Exfsys. Dbms_expfil_depasexp.schema_info_exp . Exporting statistics

The error message is reported in the Exfsys (Oracle Expression Filter component) User of the following package is also invalid, continue to use the above solution, to rebuild the user,

Solution: Remove Dmsys Users:

Sql>drop user Exfsys Cascade;

User rebuild: Rebuild the user with the following script

Sql>@?/rdbms/admin/catexf.sql

After completion of the above work, let the developer test EXP Export, exp export normal, problem solved.

Summarize:

The system user is rebuilt with Oracle's own script, and the failed objects below the system user (these objects are encrypted) are recompiled to resolve the exp error.

An Oracle EXP Export error Resolution (reproduced)