Oracle Tip: Listing the content of a .dmp file

If we have a .dmp file that has been produced using the expdp utility, it is possible to retrieve the DDL for all objects in the .dmp file by using the following options: 


impdp ... SQLFILE=myddl.sql DUMPFILE=<dumpfile>

 
If the dump file has been produced using imp utility instead, the following command will give you the list of tables:

imp ... show=Y file=<dumpfile>


This should tell you the list of objects you have in your dump file before importing it.

Unix Tip: How to format LS output

Issue
I want to use Unix ls command output and write it to a well-formatted file
Solution:
I just used the following command:

ls -ltra | awk -v OFS=";" '$1=$1'

in a bash script.
OFS parameter is used for specifying the separator for the file.

You can redirect the output to a file and then process it as it was a semicolon delimited file.