OracleDataPump tool series: How to reinstall DataPumpEXPDP/IMPDP

How to overload Datapump utility EXPDPIMPDP this article applies to OracleDatabase

How to reload 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 hang machines, internal errors, and data dictionary incompatibility.

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

In many different scenarios, you may need to reload the DATAPUMP utility, such as database hang, internal errors, 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 components of the DataPump tool, including the Metadata API that was previously installed separately. 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 the "catmetx. SQL" script.

You can use the following script to verify whether XDB is installed:

SQL> select substr (comp_name, 1, 30) comp_name, substr (comp_id, 1, 10)

Comp_id, substr (version, 1, 12) version, status from dba_registry;

If XDB is installed, the output is as follows:

Oracle XML Database XDB-version-VALID

2. 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. If necessary, execute the following script to compile invalid objects.

SQL> @ $ ORACLE_HOME/rdbms/admin/utlrp. SQL

• For Oracle version 11g:

1. Catproc. SQL

SQL> @ $ ORACLE_HOME/rdbms/admin/catproc. SQL

2. If necessary, execute the following script to compile invalid objects.

SQL> @ $ ORACLE_HOME/rdbms/admin/utlrp. SQL

Http://blog.csdn.net/xiangsir/article/details/8806457