A ready reference to exp & imp parfile
$exp parfile=ExportParfile.par
$imp parfile=ImportParfile.par
ExportParfile.par
OWNER=VSTREFWORK
FEEDBACK=10000
COMPRESS=N
STATISTICS=NONE
RECORDLENGTH=65535
BUFFER=10248000
USERID=system/password
LOG=myexp.log
FILE=myexp.dmp
DIRECT=Y speeds up export for FULL=Y Cannot be used with QUERY
ImportParfile.par
FROMUSER=VSTREFWORK
TOUSER=QATREF18
file=my_exp_file.dmp
log=my_import_log.log
grants=n
commit=y
buffer=10240000
ignore=y
statistics=none
USERID=system/password
Use SHOW=Y for running a mock imp/exp i.e. only create a log file without actually importing / exporting.
Use help for further details
exp HELP=Y
imp HELP=Y
