SET serveroutput on SIZE 1000000 exec show_dumpfile_info(p_dir⇒ 'my_dir', p_file⇒ 'expdp_f.dmp')

---

Purpose..: Obtain details about export dumpfile. Version: 18-DEC-2013 Required.: RDBMS version: 10.2.0.1.0 or higher . Export dumpfile version: 7.3.4.0.0 or higher . Export Data Pump dumpfile version: 10.1.0.1.0 or higher Usage….: execute show_dumfile_info('DIRECTORY', 'DUMPFILE'); Example..: exec show_dumfile_info('MY_DIR', 'expdp_s.dmp')

---

Filename.: ftest.dmp Directory: dpdir Disk Path: <DIRECTORY_PATH>/expdp Filetype.: 1 (Export Data Pump dumpfile)

---

…Database Job Version……….: 12.02.00.00.00 …Internal Dump File Version….: 5.1 …Creation Date……………..: Tue Jun 06 11:04:57 2017 …File Number (in dump file set): 1 …Master Present in dump file…: 1 (Yes) …Master in how many dump files.: 1 …Master Piece Number in file…: 1 …Operating System of source db.: x86_64/Linux 2.4.xx …Instance Name of source db….: db4 …Characterset ID of source db..: 873 (AL32UTF8) …Language Name of characterset.: AL32UTF8 …Job Name………………….: “<SCHEMA_NAME>”.“SYS_EXPORT_FULL_01” …GUID (unique job identifier)..: 51470FA2BE241FE4E0539395400A4A02 …Block size dump file (bytes)..: 4096 …Metadata Compressed………..: 1 (Yes) …Data Compressed……………: 0 (No) …Compression Algorithm………: 3 (Basic) …Metadata Encrypted…………: 0 (No) …Table Data Encrypted……….: 0 (No) …Column Data Encrypted………: 0 (No) …Encryption Mode……………: 2 (None) …Internal Flag Values……….: 514 …Max Items Code (Info Items)…: 23

---

PL/SQL procedure successfully completed.