Hi

I am using Datapump to export dump file from a database and while exporting the dumpfile, I am splitting that dumpfile into multiple files. Now I want to transfer those files to another server using DBMS_FILE_TRANSFER.PUT_FILE.



I know I can explicitly mention the file names in "source_file_name" but not want do that way as the file names can be different sometime.



So thinking if there is any way to put source_file_name values without bothering typing the hardcoded values.

Any help would be appreciated.

Regards,
Saptadip

for i in ( select file_name from my_external_table )
loop
  DBMS_FILE_TRANSFER.PUT_FILE(..., i.file_name, .... )
end loop;