DataPump

Find out current running jobs

SET lines 200

SELECT owner_name, job_name, operation, job_mode,
state, attached_sessions
FROM dba_datapump_jobs
ORDER BY 1,2;

Find out directories

set linesize 200
col DIRECTORY_PATH for a55
col DIRECTORY_NAME for a35
select directory_name,directory_path from dba_directories;

Clear jobs will got failed at OS level
set linesize 200
col OWNER.OBJECT for a40
SELECT o.status, o.object_id, o.object_type,
       o.owner||'.'||object_name "OWNER.OBJECT"
  FROM dba_objects o, dba_datapump_jobs j
 WHERE o.owner=j.owner_name AND o.object_name=j.job_name
   AND j.job_name NOT LIKE 'BIN$%' ORDER BY 4,2;

DROP TABLE SYSTEM.SYS_EXPORT_FULL_01;


Troubleshooting Error ORA-31633

Export: Release 11.2.0.4.0 - Production on Sat Apr 1 11:23:56 2017

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-31626: job does not exist
ORA-31633: unable to create master table "ORACLE.EXPDP_BACKUP"
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPV$FT", line 1038
ORA-00955: name is already used by an existing object

set linesize 200
col OWNER.OBJECT for a40
SELECT o.status, o.object_id, o.object_type,
       o.owner||'.'||object_name "OWNER.OBJECT"
  FROM dba_objects o, dba_datapump_jobs j
 WHERE o.owner=j.owner_name AND o.object_name=j.job_name
   AND j.job_name NOT LIKE 'BIN$%' ORDER BY 4,2;

STATUS   OBJECT_ID OBJECT_TYPE         OWNER.OBJECT
------- ---------- ------------------- ----------------------------------------
VALID       386412 TABLE               ORACLE.EXPDP_BACKUP


 drop table ORACLE.EXPDP_BACKUP;

Table dropped.

Restart datapump job, should be successful.

expdp \' sys/password@tnsname  as sysdba\' DIRECTORY=DATA_PUMP_DIR dumpfile=expdp_filename.dmp logfile=expdp_filename.log schemas=username flashback_time=systimestamp

nohup expdp \'/ as sysdba\' DIRECTORY=BCK_DP_DIR DUMPFILE=expdp_filename1.dmp logfile=expdp_filename1.log flashback_time=systimestamp full=y &


impdp \' sys/password@tnsname  as sysdba\' directory=DATA_PUMP_DIR dumpfile=expdp_filename30_SEQUENCE_050517.dmp logfile=IMP_filename30_SEQUENCE_05052017.log cluster=n remap_schema=targetuser:sourceuser