| DBMS_DATAPUMP [message #340177] |
Mon, 11 August 2008 15:48  |
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  |
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 |
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
