i think exp help=y and imp help=y will give you pretty much all the options you wants. parfiles are a simple directive or collection of those commands. a parfile config depends on how you your export taken how big is an exp etc. also if you are 10+ you might want ot look at data pump. ----- Original Message ---- From: Arif Gulzar <gulzar.arif@xxxxxxxxx> To: oracle-l@xxxxxxxxxxxxx Sent: Saturday, April 21, 2007 10:22:28 PM Subject: exp imp parfile examples Any body has exp imp parfile example for all the 4 types of exp imp...i will adjust that according to my requirment. Arif