EXPDP -Error - ORA-31626,ORA-31633,ORA-06512, ORA-06512,ORA-00955

DataPump Export Or Import Fails With Errors ORA-31633 ORA-6512 ORA-955 (Doc ID 556425.1)
oracle@sgdcplm02:/u04/MasterDB/scripts> sh expdp_SMRRAC_full.sh

Export: Release 12.1.0.2.0 - Production on Fri Oct 25 12:40:28 2019

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

Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Advanced Analytics and Real Application Testing options
ORA-31626: job does not exist
ORA-31633: unable to create master table "SYS.FULL_EXPDP_SMRRAC1"
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPV$FT", line 1048
ORA-00955: name is already used by an existing object


oracle@sgdcplm02:/u04/MasterDB/scripts> sqlplus sys/system123@smrrac1 as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Fri Oct 25 12:40:38 2019

Copyright (c) 1982, 2014, Oracle.  All rights reserved.


Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Advanced Analytics and Real Application Testing options

SQL> @d
SP2-0310: unable to open file "d.sql"
SQL> select sid, serial#, sofar, totalwork,
dp.owner_name, dp.state, dp.job_mode
from gv$session_longops sl, gv$datapump_job dp
where sl.opname = dp.job_name and sofar != totalwork;  2    3    4

no rows selected

SQL> SELECT owner_name, job_name, operation, job_mode, state, attached_sessions FROM dba_datapump_jobs WHERE job_name NOT LIKE 'BIN$%'
ORDER BY 1,2;  2

OWNER_NAME
--------------------------------------------------------------------------------
JOB_NAME
--------------------------------------------------------------------------------
OPERATION
--------------------------------------------------------------------------------
JOB_MODE
--------------------------------------------------------------------------------
STATE                          ATTACHED_SESSIONS
------------------------------ -----------------
SYS
FULL_EXPDP_SMRRAC1
EXPORT

OWNER_NAME
--------------------------------------------------------------------------------
JOB_NAME
--------------------------------------------------------------------------------
OPERATION
--------------------------------------------------------------------------------
JOB_MODE
--------------------------------------------------------------------------------
STATE                          ATTACHED_SESSIONS
------------------------------ -----------------
FULL
NOT RUNNING                                    0


OWNER_NAME
--------------------------------------------------------------------------------
JOB_NAME
--------------------------------------------------------------------------------
OPERATION
--------------------------------------------------------------------------------
JOB_MODE
--------------------------------------------------------------------------------
STATE                          ATTACHED_SESSIONS
------------------------------ -----------------
SYS
FULL_EXPDP_SMRRAC2
EXPORT

OWNER_NAME
--------------------------------------------------------------------------------
JOB_NAME
--------------------------------------------------------------------------------
OPERATION
--------------------------------------------------------------------------------
JOB_MODE
--------------------------------------------------------------------------------
STATE                          ATTACHED_SESSIONS
------------------------------ -----------------
FULL
NOT RUNNING                                    0


SQL> 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;  2

STATUS   OBJECT_ID OBJECT_TYPE
------- ---------- -----------------------
OWNER.OBJECT
--------------------------------------------------------------------------------
VALID       105403 TABLE
SYS.FULL_EXPDP_SMRRAC1

VALID       106260 TABLE
SYS.FULL_EXPDP_SMRRAC2


SQL>

Table dropped.

SQL> drop table SYS.FULL_EXPDP_SMRRAC2;

Table dropped.

SQL> 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;  2    3    4    5    6    7

no rows selected