Error running impdp 12.1.0.2.0 ORA-31626: job does not exist

[satish]

Dear Erman,
 
Facing error while importing to test instance after a successful export from prod.
 
[oraprod@erpdb1 ~]$ cat /u02/exp/t1.log
;;;
Export: Release 12.1.0.2.0 - Production on Thu Jul 22 15:43:49 2021
 
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
Starting "SYSTEM"."SYS_EXPORT_TABLE_03":  system/******** DIRECTORY=TEST_PROD DUMPFILE=refresh.dmp LOGFILE=t1.log tables=XXABC.XXABC_AP_ENGG_SSR_ITEMS_STG,XXABC.XXABC_AP_ENGG_SSR_ITEMS_TAB,XXABC.XXABC_AP_ENGG_SSR_RATES_TAB,XXABC.XXABC_AP_ENGG_SSR_CHAPTER_TAB,XXABC.XXABC_AP_ENGG_ESTIMATE_TAB,XXABC.XXABC_AP_EST_PSTN_MASTER_TAB,XXABC.XXABC_AP_EST_PSTN_MAP_TAB,XXABC.XXABC_AP_EST_PSTN_USER_MAP_TAB,XXABC.XXABC_AP_ENGG_EST_ITEM_TAB,XXABC.XXABC_AP_ENGG_EST_SUB_ITEM_TAB,XXABC.XXABC_AP_ENG_ESTIMATE_DATA_TAB,XXABC.XXABC_AP_ENGG_NSSR_ITEM_TAB,XXABC.XXABC_AP_ENGG_SUPPLY_ITEM_TAB,XXABC.XXABC_AP_ENGG_NON_CON_ITEM_TAB,XXABC.XXABC_AP_ENG_ESTIMATE_DATA_TAB,XXABC.XXABC_AP_ESTIMATE_APRVL_TRX_TL
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 27.18 MB
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type TABLE_EXPORT/TABLE/IDENTITY_COLUMN
Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type TABLE_EXPORT/TABLE/STATISTICS/MARKER
. . exported "XXABC"."XXABC_AP_ENGG_EST_ITEM_TAB"        2.869 MB    6954 rows
. . exported "XXABC"."XXABC_AP_ENG_ESTIMATE_DATA_TAB"    2.858 MB   21621 rows
. . exported "XXABC"."XXABC_AP_ENGG_SSR_ITEMS_STG"       1.319 MB    3956 rows
. . exported "XXABC"."XXABC_AP_ENGG_EST_SUB_ITEM_TAB"    2.395 MB   20173 rows
. . exported "XXABC"."XXABC_AP_ENGG_NSSR_ITEM_TAB"       1.548 MB    4174 rows
. . exported "XXABC"."XXABC_AP_ENGG_SSR_ITEMS_TAB"       2.416 MB    7664 rows
. . exported "XXABC"."XXABC_AP_ENGG_SSR_RATES_TAB"       988.7 KB   16705 rows
. . exported "XXABC"."XXABC_AP_ENGG_ESTIMATE_TAB"        180.1 KB     617 rows
. . exported "XXABC"."XXABC_AP_ENGG_NON_CON_ITEM_TAB"    121.5 KB     864 rows
. . exported "XXABC"."XXABC_AP_ESTIMATE_APRVL_TRX_TL"    86.80 KB     667 rows
. . exported "XXABC"."XXABC_AP_EST_PSTN_MAP_TAB"         35.10 KB     280 rows
. . exported "XXABC"."XXABC_AP_EST_PSTN_USER_MAP_TAB"    61.82 KB     463 rows
. . exported "XXABC"."XXABC_AP_ENGG_SSR_CHAPTER_TAB"     19.28 KB      49 rows
. . exported "XXABC"."XXABC_AP_ENGG_SUPPLY_ITEM_TAB"     48.73 KB     133 rows
. . exported "XXABC"."XXABC_AP_EST_PSTN_MASTER_TAB"      27.49 KB     118 rows
Master table "SYSTEM"."SYS_EXPORT_TABLE_03" successfully loaded/unloaded
******************************************************************************
Dump file set for SYSTEM.SYS_EXPORT_TABLE_03 is:
  /u02/exp/refresh.dmp
Job "SYSTEM"."SYS_EXPORT_TABLE_03" successfully completed at Thu Jul 22 15:47:56 2021 elapsed 0 00:04:00
_EXPORT_TABLE_01" successfully completed at Thu Jul 22 15:45:35 2021 elapsed 0 00:04:32
[oraprod@erpdb1 ~]$
 
 
 
 
[orasupp@erpsupportdb ~]$ impdp system/manager123 tables=XXABC.XXABC_AP_ENGG_SSR_ITEMS_STG,XXABC.XXABC_AP_ENGG_SSR_ITEMS_TAB,XXABC.XXABC_AP_ENGG_SSR_RATES_TAB,XXABC.XXABC_AP_ENGG_SSR_CHAPTER_TAB,XXABC.XXABC_AP_ENGG_ESTIMATE_TAB,XXABC.XXABC_AP_EST_PSTN_MASTER_TAB,XXABC.XXABC_AP_EST_PSTN_MAP_TAB,XXABC.XXABC_AP_EST_PSTN_USER_MAP_TAB,XXABC.XXABC_AP_ENGG_EST_ITEM_TAB,XXABC.XXABC_AP_ENGG_EST_SUB_ITEM_TAB,XXABC.XXABC_AP_ENG_ESTIMATE_DATA_TAB,XXABC.XXABC_AP_ENGG_NSSR_ITEM_TAB,XXABC.XXABC_AP_ENGG_SUPPLY_ITEM_TAB,XXABC.XXABC_AP_ENGG_NON_CON_ITEM_TAB,XXABC.XXABC_AP_ENG_ESTIMATE_DATA_TAB,XXABC.XXABC_AP_ESTIMATE_APRVL_TRX_TL DIRECTORY=TEST_PROD dumpfile=refresh.dmp table_exists_action=truncate
 
Import: Release 12.1.0.2.0 - Production on Thu Jul 22 16:20:01 2021
 
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, OLAP, Advanced Analytics and Real Application Testing options
ORA-31626: job does not exist

[satish]

Fix:

Grant read,write on directory test_prod to apps;

Reran import and it is successful.

Thank you