<<Back to Oracle DATAPUMP Main Page
How to Retain Master Table of completed Export or Import Jobs
Use KEEP_MASTER parameterDefault: NO
Syntax and DescriptionKEEP_MASTER=[YES | NO]
$ cat exp_full_pdb01.par
DIRECTORY=DUMP
DUMPFILE=EXP_PDB01_FULL%U.DMP
LOGFILE=EXP_PDB01_FULL.LOG
FULL=Y
REUSE_DUMPFILES=Y
FLASHBACK_TIME=SYSTIMESTAMP
JOB_NAME=MY_EXPORT_JOB
KEEP_MASTER=Y
You can query the status of export/import jobs by attaching to the job even if it completed only if you have used KEEP_MASTER=Y parameter while performing export/import. If you have not used the parameter and try to query the status you will see errors similar to this
expdp system@PDB01 attach=MY_EXPORT_JOB
Export: Release 12.2.0.1.0 - Production on Wed Oct 24 16:21:38 2018
Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved.
Password:
Connected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
ORA-31626: job does not exist
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79
ORA-06512: at "SYS.KUPV$FT", line 408
ORA-31638: cannot attach to job MY_EXPORT_JOB for user SYSTEM
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPV$FT", line 401
ORA-31632: master table "SYSTEM.MY_EXPORT_JOB" not found, invalid, or inaccessible
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPV$FT", line 393
ORA-00942: table or view does not exist
ORA-06512: at "SYS.KUPV$FT_INT", line 2578
ORA-06512: at "SYS.KUPV$FT", line 205
Comments
Post a Comment