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

@?\rdbms\admin\dpload.sql;

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.

@?\rdbms\admin\utlrp.sql;

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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.