How to Show Content of Oracle Dump/Export (.dmp) File

SHOW=y option of the IMP utility allows you to see the content of an Oracle dump/export file (.dmp).

When this option is specified, IMP outputs the SQL statements contained in the export file in the order in which Import will execute them.

IMP utility outputs the content to the screen, and you can re-direct it to a file:

  IMP USERID=scott/tiger FULL=y SHOW=y FILE=oraexp.dmp > oraexp_dmp.sql 2>&1

Note. IMP sends its output to stderr (standard error output).