|
|
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
|
Locked
