DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Monday, August 31, 2015

Data Pump Parameter-Job_name




Data Pump Parameter-Job_name

expdp system/oracle directory=TEST_DIR tablespace=users dumpfile=tbs.dmp JOB_NAME=myJob




SQL> select * from dba_datapump_jobs;

OWNER_NAME                     JOB_NAME                       OPERATION                      JOB_MODE                       STATE                          DEGREE ATTACHED_SESSIONS DATAPUMP_SESSIONS
------------------------------ ------------------------------ ------------------------------ ------------------------------ ------------------------------ ---------- ----------------- -----------------
SYSTEM                         MYJOB                          EXPORT                         TABLESPACE                     EXECUTING                   1                  1                 3




[oracle@oracle11g ~]$ expdp system/oracle directory=TEST_DIR tablespaces=users dumpfile=tbs.dmp JOB_NAME=myJob

Export: Release 11.2.0.3.0 - Production on Mon Aug 31 12:11:32 2015

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting "SYSTEM"."MYJOB":  system/******** directory=TEST_DIR tablespaces=users dumpfile=tbs.dmp JOB_NAME=myJob
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 1.503 GB
Processing object type TABLE_EXPORT/TABLE/TABLE
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

No comments: