Author Archives: SandeepSingh DBA

About SandeepSingh DBA

Hi, I am working in IT industry with having more than 10 year of experience, worked as an Oracle DBA with a Company and handling different databases like Oracle, SQL Server , DB2 etc Worked as a Development and Database Administrator.

Check the datapump file header information in Oracle

Check the data pump file information before importing in Oracle



CONNECT / as sysdba
CREATE DIRECTORY DUMPDIR AS '/u02/data/dump/expdp';
GRANT read, write ON DIRECTORY DUMPDIR TO system;

SET serveroutput on SIZE 1000000
exec show_dumpfile_info(p_dir=> 'DUMPDIR', p_file=> '<dumpfile name>')

SET serveroutput on SIZE 1000000
exec show_dumpfile_info(p_dir=> 'DUMPDIR', p_file=> 'expdp_hr.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('DUMPDIR', 'expdp_hr.dmp')
----------------------------------------------------------------------
Filename.: expdp_hr.dmp
Directory: DUMPDIR
Disk Path: /u02/data/dump/expdp
Filetype.: 1 (Export Data Pump dumpfile)
-----------------------------------------------------------------------
...Database Job Version..........: 12.02.00.00.00
...Internal Dump File Version....: 5.1
...Creation Date.................: Sun Jan 17 10:35:57 2021
...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.