<<Back to Oracle DATAPUMP Main Page
How to Give a Name to an Export or Import Job
In some you don't want to use system generated names for an export or import jobs but you want to assign name to recognize the jobs easily while attaching to the job or while querying information from DBA_DATAPUMP_JOBS. You can use JOB_NAME parameter of expdp or impdp utility to achieve the sameJOB_NAME
Default: system-generated name of the form SYS_EXPORT_<mode>_NN <= in export
Default: system-generated name of the form SYS_<IMPORT or SQLFILE>_<mode>_NN <= in import
Syntax and DescriptionJOB_NAME=jobname_string
An example:
$ 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
$ expdp system@PDB01 parfile=exp_full_pdb01.par
Export: Release 12.2.0.1.0 - Production on Wed Oct 24 16:14: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
Starting "SYSTEM"."MY_EXPORT_JOB": system/********@PDB01 parfile=exp_full_pdb01.par
How to Attach to an Export/Import Job
$ expdp system@PDB01 attach=MY_EXPORT_JOBExport: Release 12.2.0.1.0 - Production on Wed Oct 24 16:16:07 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
Job: MY_EXPORT_JOB
Owner: SYSTEM
Operation: EXPORT
Creator Privs: TRUE
GUID: 78FB1BE335DA037CE0530601B8C07886
Start Time: Wednesday, 24 October, 2018 16:15:03
Mode: FULL
Instance: TST2T
Max Parallelism: 1
Timezone: +02:00
Timezone version: 26
Endianness: LITTLE
NLS character set: AL32UTF8
NLS NCHAR character set: AL16UTF16
EXPORT Job Parameters:
Parameter Name Parameter Value:
CLIENT_COMMAND system/********@PDB01 parfile=exp_full_pdb01.par
FLASHBACK_TIME 18-OCT-24 04:15:06 PM
TRACE 0
State: EXECUTING
Bytes Processed: 0
Current Parallelism: 1
Job Error Count: 0
Job heartbeat: 2
Dump File: /u01/tmp/stage/dump/EXP_PDB01_FULL01.dmp
bytes written: 16,384
Dump File: /u01/tmp/stage/dump/EXP_PDB01_FULL%u.dmp
Worker 1 Status:
Instance ID: 1
Instance name: TST2T
Host name: node1
Object start time: Wednesday, 24 October, 2018 16:15:54
Object status at: Wednesday, 24 October, 2018 16:15:56
Process Name: DW00
State: EXECUTING
Comments
Post a Comment