Saturday, September 24, 2011

STATUS parameter in datapump


STATUS:

Specifies the frequency at which the job status display is updated.
If you supply a value for integer, it specifies how frequently, in seconds, job status should be displayed in logging mode.

DEMO:

SQL> host expdp system/sys dumpfile=EasdXPgjhDAT.dmp directory=ipump full=y status=10

Export: Release 11.2.0.1.0 - Production on Sat Sep 24 12:13:07 2011

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

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

Job: SYS_EXPORT_FULL_05
  Operation: EXPORT
  Mode: FULL
  State: EXECUTING
  Bytes Processed: 0
  Current Parallelism: 1
  Job Error Count: 0
  Dump File: D:\EASDXPGJHDAT.DMP
    bytes written: 4,096

Worker 1 Status:
  State: UNDEFINED
Starting "SYSTEM"."SYS_EXPORT_FULL_05":  system/******** dumpfile=EasdXPgjhDAT.dmp directory=ipump full=y status=10

Job: SYS_EXPORT_FULL_05
  Operation: EXPORT
  Mode: FULL
  State: EXECUTING
  Bytes Processed: 0
  Current Parallelism: 1
  Job Error Count: 0
  Dump File: D:\EASDXPGJHDAT.DMP
    bytes written: 4,096

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

Job: SYS_EXPORT_FULL_05
  Operation: EXPORT
  Mode: FULL
  State: EXECUTING
  Bytes Processed: 0
  Current Parallelism: 1
  Job Error Count: 0
  Dump File: D:\EASDXPGJHDAT.DMP
    bytes written: 4,096

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

Job: SYS_EXPORT_FULL_05
....

Enjoy:-)