Reinstall datapump on 10g

Sometimes, very often due to miss use, your Datapump setup is all messy. One thing left, clean it up and reinstall it.


To quickly cleanup datapump objects:

Identify datapump objects :

select * from dba_objects where object_name like 'SYS_EXPORT%'

Next identify object currently accessed :

select * from v$access where object like 'SYS_EXPORT%'

The objects that are present on dba_objects but not on v$access can be dropped


And the Datapump installation procedure

Catdph.sql will Re-Install DataPump types and views=

SQL> @?/rdbms/admin/catdph.sql

Note: If XDB is installed the it is required to run "catmetx.sql" script also.

prvtdtde.plb will Re-Install tde_library packages

SQL> @?/rdbms/admin/prvtdtde.plb

Catdpb.sql will Re-Install DataPump packages

SQL> @?/rdbms/admin/catdpb.sql

Dbmspump.sql will Re-Install DBMS DataPump objects

SQL> @?/rdbms/admin/dbmspump.sql

To recompile invalid objects, if any

SQL> @?/rdbms/admin/utlrp.sql