Oracle Data Pump tool series: How to reinstall DataPump EXPDP/IMPDP

Oracle Data Pump tool series: how to reinstall the DataPump EXPDP/IMPDP tool and how to reload the Datapump utility EXPDP/IMPDP this article applies to OracleDatabase-Enterprise Edition-Version 10.1.0.2 to 11.2.0.3 which may need to be reloaded in many different scenarios, for example, the database has all problems related to the DataPump initialization phase, such as the hang machine, internal error, and data dictionary incompatibility.
In some cases, the DataPump utility may be damaged. We need to recreate the DataPump utility to solve some internal damages. To perform this operation, follow the script below: Note: run the following script as sysdba: SQL> connect/as sysdba for Oracle version 10.1: 1. catdp. SQL is responsible for installing all the components of the DataPump tool, including the Metadata API that was previously separately installed. By default, catproc. SQL calls this script. SQL> @ $ ORACLE_HOME/rdbms/admin/catdp. SQL 2. dbmspump. SQL is used to create the DBMS process used by DataPump. SQL> @ $ ORACLE_HOME/rdbms/admin/dbmspump. SQL for Oracle version 10.2: 1. catdph. SQL is used to reinstall the DataPump type and view SQL> @ $ ORACLE_HOME/rdbms/admin/catdph. SQL Note: If XDB is installed, Run "catmetx. SQL "script. Run the following script to verify whether XDB has been installed: SQL> select substr (comp_name,) comp_name, substr (comp_id,) comp_id, substr (version,) version, status from dba_registry; If XDB is installed, Oracle XML Database XDB-version-VALID 2 is output as follows. prvtdtde. plb is used to reinstall the tde_library Package SQL> @ $ ORACLE_HOME/rdbms/admin/prvtdtde. plb 3. catdpb. SQL is used to reinstall the DataPump Package SQL> @ $ ORACLE_HOME/rdbms/admin/catdpb. SQL 4. dbmspump. SQL is used to reinstall the DBMS DataPump object SQL> @ $ ORACLE_HOME/rdbms/admin/dbmspump. SQL 5. execute the following script to compile Invalid object SQL> @ $ ORACLE_HOME/rdbms/admin/utlrp. sqlFor Oracle version 11g: 1. catproc. SQL SQL> @ $ ORACLE_HOME/rdbms/admin/catproc. SQL 2. execute the following script to compile Invalid object SQL> @ $ ORACLE_HOME/rdbms/admin/utlrp. SQL Source: http://blog.csdn.net/xiangsir/article/details/8806457