Rebuild the DataPump packages in Oracle

Rebuild the DataPump packages in Oracle

Following are the steps to rebuild the DATAPUMP packages in Oracle
Note: If EXPDP or IMPDP is having problem is corrupted or not running then we can tried to recreate their packages.

1. Check the invalid objects or components in your database.

set pages 1000
set lines 120
col owner format a24
col object_name format a30
col object_type format a30
col comp_id format a20
col comp_name format a40
col version format a10
col status format a15
-- Check components
select comp_id,comp_name,version,status from dba_registry
order by 1;
-- Check objects
SELECT owner, object_name, object_type,object_id FROM dba_objects
WHERE status != 'VALID'
ORDER BY 1,3;

2. For 10g or 11g version: Execute the following steps by opening database in upgrade mode.
Note: If you are in Oracle 12c follow step 3 only.

shutdown immediate;
startup upgrade;
@$ORACLE_HOME/rdbms/admin/catalog.sql
@$ORACLE_HOME/rdbms/admin/catproc.sql
@$ORACLE_HOME/rdbms/admin/utlrp.sql
@$ORACLE_HOME/rdbms/admin/utlrp.sql
shutdown immediate;
startup

3. For Oracle 12c, only run the DPLOAD.SQL utility
Note: In CDB environment, all PDBS must be in open state.

@$ORACLE_HOME/rdbms/admin/dpload.sql;

1 thought on “Rebuild the DataPump packages in Oracle

  1. Pingback: ORA-31650: timeout waiting for master process response | Smart way of Technology

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 )

Google photo

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

Twitter picture

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