Reload or Rebuild the datapump utility in Oracle

Datapump issue then recreate the utility in Oracle

  1. Go to the directory in Oracle Home.
cd $ORACLE_HOME\rdbms\admin

2. Connect with SQL Plus with SYSDBA role.

SQLPLUS sys as sysdba


Note: If you have the PDB database then rerun for the PDB database separately.

3, After execute dpload.sql, we need to recompile all the invalid objects.


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.