Data Pump EXPDP IMPDP Status Parameter for Feedback

In conventional exp / imp we have feedback parameter to see the progress of each table’s export. If you give feedback=1000 then in the output it will show a dot ‘.’ For each and every thousand number of rows. In the data pump does not have the feedback option whereas it has STATUS option available to report the status of the export or import activity in the seconds mentioned as the parameter value.


Example:
expdp schemas=scott directory=exp_dir dumpfile=status_test.dmp logfile=status_test.log compression=all status=60

Export: Release 11.2.0.2.0 - Production on Sat May 12 09:19:29 2012

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

Username: / as sysdba

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options

Job: SYS_EXPORT_SCHEMA_01
  Operation: EXPORT
  Mode: SCHEMA
  State: EXECUTING
  Bytes Processed: 0
  Current Parallelism: 1
  Job Error Count: 0
  Dump File: /home/oracle/export/status_test.dmp
    bytes written: 4,096

Worker 1 Status:
  State: UNDEFINED
Starting "SYS"."SYS_EXPORT_SCHEMA_01":  /******** AS SYSDBA schemas=scott directory=exp_dir dumpfile=status_test.dmp logfile=status_test.log compression=all status=60

Job: SYS_EXPORT_SCHEMA_01
  Operation: EXPORT
  Mode: SCHEMA
  State: EXECUTING
  Bytes Processed: 0
  Current Parallelism: 1
  Job Error Count: 0
  Dump File: /home/oracle/export/status_test.dmp
    bytes written: 4,096

Worker 1 Status:
  Process Name: DW00
  State: EXECUTING
Estimate in progress using BLOCKS method...

Job: SYS_EXPORT_SCHEMA_01
  Operation: EXPORT
  Mode: SCHEMA
  State: EXECUTING
  Bytes Processed: 0
  Current Parallelism: 1
  Job Error Count: 0
  Dump File: /home/oracle/export/status_test.dmp
    bytes written: 4,096

Worker 1 Status:
  Process Name: DW00
  State: EXECUTING
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA

Job: SYS_EXPORT_SCHEMA_01
  Operation: EXPORT
  Mode: SCHEMA
  State: EXECUTING
  Bytes Processed: 0
  Current Parallelism: 1
  Job Error Count: 0
  Dump File: /home/oracle/export/status_test.dmp
    bytes written: 4,096

Worker 1 Status:
  Process Name: DW00
  State: EXECUTING
  Object Schema: SCOTT
  Object Name: EMP
  Object Type: SCHEMA_EXPORT/TABLE/TABLE_DATA
  Completed Objects: 8
  Worker Parallelism: 1
Total estimation using BLOCKS method: 860.2 MB

Job: SYS_EXPORT_SCHEMA_01
  Operation: EXPORT
  Mode: SCHEMA
  State: EXECUTING
  Bytes Processed: 0
  Current Parallelism: 1
  Job Error Count: 0
  Dump File: /home/oracle/export/status_test.dmp
    bytes written: 4,096

Worker 1 Status:
  Process Name: DW00
  State: EXECUTING
  Object Schema: SCOTT
  Object Name: EMP
  Object Type: SCHEMA_EXPORT/TABLE/TABLE_DATA
  Completed Objects: 8
  Total Objects: 8
  Worker Parallelism: 1
Processing object type SCHEMA_EXPORT/USER
. . .
. . .
. . .
. . .
Job: SYS_EXPORT_SCHEMA_01
  Operation: EXPORT
  Mode: SCHEMA
  State: COMPLETED
  Bytes Processed: 110,940,233
  Percent Done: 100
  Current Parallelism: 1
  Job Error Count: 0
  Dump File: /home/oracle/export/status_test.dmp
    bytes written: 111,063,040

Worker 1 Status:
  Process Name: DW00
  State: WORK WAITING
Job "SYS"."SYS_EXPORT_SCHEMA_01" successfully completed at 09:20:38
DBA Tips Data Pump Reference

0 comments:

Post a Comment

 

dba topics. Copyright 2011-16 All Rights Reserved | Site Map | Contact | Disclaimer | Google