Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How we can get the information of how many dump files got created after export?

User_T-OracleNov 3 2022 — edited Nov 3 2022

Hello
I'm using data pump export in an application where it is required to determine the number of dump files got created for that table export.
I'm using filesize parameter in a data pump export,
dbms_datapump.add_file(
handle => l_dp_handle,
filename => 'tab_12345_part_%U.dmp',
directory => 'DPUMP_DIR',
filesize => '10M');
After export is completed, how can I get the number of files got created in this export job.?
Is data pump has any parameter which indicates the number of dump file is got created for that job ?
Can anybody please help me on this ?
Thanks
T

This post has been answered by Jason_(A_Non) on Nov 4 2022
Jump to Answer
Comments
Post Details
Added on Nov 3 2022
5 comments
909 views