ORA-31626: job does not exist while impdp
Hi Experts,
Our database versiob 12.1.0.2
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