Home » RDBMS Server » Server Utilities » DBMS_DATAPUMP (Oracle 10g, HP Unix)
DBMS_DATAPUMP [message #340177] Mon, 11 August 2008 15:48 Go to next message
proj_02_att
Messages: 2
Registered: August 2008
Location: Bothell
Junior Member
I have requirement to record number of rows exported/imported during datapump. Currently we run old process using exp/imp utility from shell and at the end parsing log file:
finaltot=`cat ${EXPLOG}| grep "exporting" | grep "exported" | grep $n| awk 'BEGIN {s=0} {s+=$6;} END {print s}'`. I cannot find anywhere way to get number of rows processed using datapump API. Is it possible? Any help/advice greatly appreciated.
Re: DBMS_DATAPUMP [message #340233 is a reply to message #340177] Tue, 12 August 2008 01:05 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Just use the LOGFILE parameter with EXPDP/IMPDP utility
after export/import check LOGFILE
You will see something like below
. . exporting table                  PMDESIGNATION         [B]1000 rows exported[/B]
. . exporting table                     PMEMPLOYEE        78400 rows exported
. . exporting table                   PMEMPREMARKS         18000 rows exported

[Updated on: Tue, 12 August 2008 01:18] by Moderator

Report message to a moderator

Re: DBMS_DATAPUMP [message #340409 is a reply to message #340233] Tue, 12 August 2008 11:48 Go to previous message
proj_02_att
Messages: 2
Registered: August 2008
Location: Bothell
Junior Member
Thank you for response. However, I am looking for the way to retrieve this value through API or some PL/SQL function/procedure.
Previous Topic: NO RECORDS SELECTED error
Next Topic: How to read content from a datapump file
Goto Forum:
  


Current Time: Mon Dec 05 19:09:20 CST 2016

Total time taken to generate the page: 0.08542 seconds