DB version: 11.2.0.4
OS : RHEL 6.4
In original export (exp ), to export big tables, I used to use FEEDBACK=100000 . This will print one dot for every 100,000 rows exported.
I understand there is no such equivalent in expdp. The closest one is STATUS parameter.
If I understand correctly , if I set status=1800 , then expdp will print status of the job every 30 minutes.
As a test, I started export of the below table with nearly 2 Million rows thinking that it will take around 1.5 hours to complete. But, it took only less than a minute to complete. Although it shows "Completed Rows" the STATUS output has much more info than I need. In a period of less than 40 seconds, it has printed all these lines below. I thought it will print the 'Status' only every 30 minutes.
I just want to see "Completed Rows" or something very minimal every 30 minutes . Is there a way?
expdp "'/ as sysdba'" DIRECTORY=DATA_PUMP_DIR PARALLEL=2 DUMPFILE= ORDER_MASTER_expdp_%U.dmp status=1800 LOGFILE=ORDER_MASTER-exp.log tables = UIM.ORDER_MASTER
$ tail -f ORDER_MASTER-exp.log
Export: Release 11.2.0.4.0 - Production on Wed Dec 30 17:17:45 2015
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Job: SYS_EXPORT_TABLE_01
Operation: EXPORT
Mode: TABLE
State: EXECUTING
Bytes Processed: 0
Current Parallelism: 2
Job Error Count: 0
Dump File: /u07/dpdump/ORDER_MASTER_expdp_01.dmp
bytes written: 4,096
Dump File: /u07/dpdump/ORDER_MASTER_expdp_%u.dmp
Worker 1 Status:
State: UNDEFINED
Starting "SYS"."SYS_EXPORT_TABLE_01": "/******** AS SYSDBA" DIRECTORY=DATA_PUMP_DIR PARALLEL=2 dumpfile= status=1800 LOGFILE=ORDER_MASTER-exp.log tables=UIM.ORDER_MASTER
Job: SYS_EXPORT_TABLE_01
Operation: EXPORT
Mode: TABLE
State: EXECUTING
Bytes Processed: 0
Current Parallelism: 2
Job Error Count: 0
Dump File: /u07/dpdump/ORDER_MASTER_expdp_01.dmp
bytes written: 4,096
Dump File: /u07/dpdump/ORDER_MASTER_expdp_%u.dmp
Worker 1 Status:
Process Name: DW00
State: EXECUTING
Estimate in progress using BLOCKS method...
Job: SYS_EXPORT_TABLE_01
Operation: EXPORT
Mode: TABLE
State: EXECUTING
Bytes Processed: 0
Current Parallelism: 2
Job Error Count: 0
Dump File: /u07/dpdump/ORDER_MASTER_expdp_01.dmp
bytes written: 4,096
Dump File: /u07/dpdump/ORDER_MASTER_expdp_%u.dmp
Worker 1 Status:
Process Name: DW00
State: EXECUTING
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Job: SYS_EXPORT_TABLE_01
Operation: EXPORT
Mode: TABLE
State: EXECUTING
Bytes Processed: 0
Current Parallelism: 2
Job Error Count: 0
Dump File: /u07/dpdump/ORDER_MASTER_expdp_01.dmp
bytes written: 4,096
Dump File: /u07/dpdump/ORDER_MASTER_expdp_%u.dmp
Worker 1 Status:
Process Name: DW00
State: EXECUTING
Object Schema: UIM
Object Name: ORDER_MASTER
Object Type: TABLE_EXPORT/TABLE/TABLE_DATA
Completed Objects: 1
Total Objects: 1
Worker Parallelism: 1
Worker 2 Status:
State: UNDEFINED
Total estimation using BLOCKS method: 344 MB
Job: SYS_EXPORT_TABLE_01
Operation: EXPORT
Mode: TABLE
State: EXECUTING
Bytes Processed: 0
Current Parallelism: 2
Job Error Count: 0
Dump File: /u07/dpdump/ORDER_MASTER_expdp_01.dmp
bytes written: 4,096
Dump File: /u07/dpdump/ORDER_MASTER_expdp_%u.dmp
Worker 1 Status:
Process Name: DW00
State: EXECUTING
Object Schema: UIM
Object Name: ORDER_MASTER
Object Type: TABLE_EXPORT/TABLE/TABLE_DATA
Completed Objects: 1
Total Objects: 1
Completed Rows: 918,646
Worker Parallelism: 1
Worker 2 Status:
Process Name: DW01
State: EXECUTING
Object Schema: UIM
Object Name: ORDER_MASTER
Object Type: TABLE_EXPORT/TABLE/TABLE_DATA
Completed Objects: 1
Total Objects: 1
Completed Rows: 918,646
Worker Parallelism: 1
Processing object type TABLE_EXPORT/TABLE/TABLE
Job: SYS_EXPORT_TABLE_01
Operation: EXPORT
Mode: TABLE
State: EXECUTING
Bytes Processed: 323,896,592
Percent Done: 99
Current Parallelism: 2
Job Error Count: 0
Dump File: /u07/dpdump/ORDER_MASTER_expdp_01.dmp
bytes written: 323,903,488
Dump File: /u07/dpdump/ORDER_MASTER_expdp_%u.dmp
Worker 1 Status:
Process Name: DW00
State: EXECUTING
Object Schema: UIM
Object Name: ORDER_MASTER
Object Type: TABLE_EXPORT/TABLE/TABLE
Completed Objects: 1
Worker Parallelism: 1
Worker 2 Status:
Process Name: DW01
State: WORK WAITING
. . exported "UIM"."ORDER_MASTER" 308.8 MB 1883437 rows
Job: SYS_EXPORT_TABLE_01
Operation: EXPORT
Mode: TABLE
State: EXECUTING
Bytes Processed: 323,896,592
Percent Done: 99
Current Parallelism: 2
Job Error Count: 0
Dump File: /u07/dpdump/ORDER_MASTER_expdp_01.dmp
bytes written: 323,903,488
Dump File: /u07/dpdump/ORDER_MASTER_expdp_%u.dmp
Worker 1 Status:
Process Name: DW00
State: EXECUTING
Object Schema: UIM
Object Name: ORDER_MASTER
Object Type: TABLE_EXPORT/TABLE/TABLE
Completed Objects: 1
Total Objects: 1
Worker Parallelism: 1
Worker 2 Status:
Process Name: DW01
State: WORK WAITING
Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX
Job: SYS_EXPORT_TABLE_01
Operation: EXPORT
Mode: TABLE
State: EXECUTING
Bytes Processed: 323,896,592
Percent Done: 99
Current Parallelism: 2
Job Error Count: 0
Dump File: /u07/dpdump/ORDER_MASTER_expdp_%u.dmp
Dump File: /u07/dpdump/ORDER_MASTER_expdp_01.dmp
bytes written: 323,903,488
Dump File: /u07/dpdump/ORDER_MASTER_expdp_02.dmp
bytes written: 4,096
Worker 1 Status:
Process Name: DW00
State: EXECUTING
Object Schema: UIM
Object Name: IDX_DIFF_CAT_SEQ
Object Type: TABLE_EXPORT/TABLE/INDEX/INDEX
Completed Objects: 2
Total Objects: 2
Worker Parallelism: 1
Worker 2 Status:
Process Name: DW01
State: WORK WAITING
Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Job: SYS_EXPORT_TABLE_01
Operation: EXPORT
Mode: TABLE
State: EXECUTING
Bytes Processed: 323,896,592
Percent Done: 99
Current Parallelism: 2
Job Error Count: 0
Dump File: /u07/dpdump/ORDER_MASTER_expdp_%u.dmp
Dump File: /u07/dpdump/ORDER_MASTER_expdp_01.dmp
bytes written: 323,903,488
Dump File: /u07/dpdump/ORDER_MASTER_expdp_02.dmp
bytes written: 4,096
Worker 1 Status:
Process Name: DW00
State: EXECUTING
Object Type: TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Completed Objects: 2
Total Objects: 2
Worker Parallelism: 1
Worker 2 Status:
Process Name: DW01
State: WORK WAITING
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Job: SYS_EXPORT_TABLE_01
Operation: EXPORT
Mode: TABLE
State: EXECUTING
Bytes Processed: 323,896,593
Percent Done: 99
Current Parallelism: 2
Job Error Count: 0
Dump File: /u07/dpdump/ORDER_MASTER_expdp_%u.dmp
Dump File: /u07/dpdump/ORDER_MASTER_expdp_01.dmp
bytes written: 323,903,488
Dump File: /u07/dpdump/ORDER_MASTER_expdp_02.dmp
bytes written: 16,384
Worker 1 Status:
Process Name: DW00
State: WORK WAITING
Worker 2 Status:
Process Name: DW01
State: WORK WAITING
Master table "SYS"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded
Job: SYS_EXPORT_TABLE_01
Operation: EXPORT
Mode: TABLE
State: EXECUTING
Bytes Processed: 323,896,593
Percent Done: 99
Current Parallelism: 2
Job Error Count: 0
Dump File: /u07/dpdump/ORDER_MASTER_expdp_%u.dmp
Dump File: /u07/dpdump/ORDER_MASTER_expdp_01.dmp
bytes written: 323,903,488
Dump File: /u07/dpdump/ORDER_MASTER_expdp_02.dmp
bytes written: 16,384
Worker 1 Status:
Process Name: DW00
State: WORK WAITING
Worker 2 Status:
Process Name: DW01
State: WORK WAITING
******************************************************************************
Job: SYS_EXPORT_TABLE_01
Operation: EXPORT
Mode: TABLE
State: EXECUTING
Bytes Processed: 323,896,593
Percent Done: 99
Current Parallelism: 2
Job Error Count: 0
Dump File: /u07/dpdump/ORDER_MASTER_expdp_%u.dmp
Dump File: /u07/dpdump/ORDER_MASTER_expdp_01.dmp
bytes written: 323,903,488
Dump File: /u07/dpdump/ORDER_MASTER_expdp_02.dmp
bytes written: 16,384
Worker 1 Status:
Process Name: DW00
State: WORK WAITING
Worker 2 Status:
Process Name: DW01
State: WORK WAITING
Dump file set for SYS.SYS_EXPORT_TABLE_01 is:
Job: SYS_EXPORT_TABLE_01
Operation: EXPORT
Mode: TABLE
State: EXECUTING
Bytes Processed: 323,896,593
Percent Done: 99
Current Parallelism: 2
Job Error Count: 0
Dump File: /u07/dpdump/ORDER_MASTER_expdp_%u.dmp
Dump File: /u07/dpdump/ORDER_MASTER_expdp_01.dmp
bytes written: 323,903,488
Dump File: /u07/dpdump/ORDER_MASTER_expdp_02.dmp
bytes written: 16,384
Worker 1 Status:
Process Name: DW00
State: WORK WAITING
Worker 2 Status:
Process Name: DW01
State: WORK WAITING
/u07/dpdump/ORDER_MASTER_expdp_01.dmp
Job: SYS_EXPORT_TABLE_01
Operation: EXPORT
Mode: TABLE
State: COMPLETING
Bytes Processed: 323,896,593
Percent Done: 100
Current Parallelism: 2
Job Error Count: 0
Dump File: /u07/dpdump/ORDER_MASTER_expdp_%u.dmp
Dump File: /u07/dpdump/ORDER_MASTER_expdp_01.dmp
bytes written: 323,903,488
Dump File: /u07/dpdump/ORDER_MASTER_expdp_02.dmp
bytes written: 16,384
Worker 1 Status:
Process Name: DW00
State: WORK WAITING
Worker 2 Status:
Process Name: DW01
State: WORK WAITING
/u07/dpdump/ORDER_MASTER_expdp_02.dmp
Job: SYS_EXPORT_TABLE_01
Operation: EXPORT
Mode: TABLE
State: COMPLETED
Bytes Processed: 323,896,593
Percent Done: 100
Current Parallelism: 2
Job Error Count: 0
Dump File: /u07/dpdump/ORDER_MASTER_expdp_%u.dmp
Dump File: /u07/dpdump/ORDER_MASTER_expdp_01.dmp
bytes written: 323,903,488
Dump File: /u07/dpdump/ORDER_MASTER_expdp_02.dmp
bytes written: 16,384
Worker 1 Status:
Process Name: DW00
State: WORK WAITING
Worker 2 Status:
Process Name: DW01
State: WORK WAITING
Job "SYS"."SYS_EXPORT_TABLE_01" successfully completed at Wed Dec 30 17:18:13 2015 elapsed 0 00:00:19