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:-)

2 comments:

yanmaneee said...

vapormax
longchamp handbags
yeezy shoes
canada goose jacket
jordan shoes
curry 5
adidas tubular shadow
chrome hearts online store
retro jordans
hermes

sheau said...

useful reference y3t34q6l20 Louis Vuitton replica Bags replica bags gucci q3p76x2s91 redirected here d6j78l9e59 Ysl replica replica ysl bags australia replica bags paypal hermes replica o2h15k9c66 replica bags paypal accepted