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;
This entry was posted in Oracle on by .
Unknown's avatar

About SandeepSingh

Hi, I am working in IT industry with having more than 15 year of experience, worked as an Oracle DBA with a Company and handling different databases like Oracle, SQL Server , DB2 etc Worked as a Development and Database Administrator.

Leave a Reply