Datapump issue then recreate the utility in Oracle
- 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;