advertisements
_____________________________________________________________________________________________________________________
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
_____________________________________________________________________________________________________________________
0 comments:
Post a Comment