Hoping someone could tell me if I am using the correct command to import 2 tables that were accidently truncated? Long story but this is a Solaris Oracle environment which the DBA quit and they are interviewing for a replacement. Blah Blah!! Anyway I found the export cron output listed below which is using a PAR file. So to do a quick import do I just create an import par file using those params below and adding parameter tables=(table1, table2) and run this command?.....
/opt/oracle/product/10.2.0/db_2/bin/imp parfile=/var/opt/oracle/tmp/import_dodpb.par file=/opt/oracle/backup/exports/dodpb/data_dodpb_exp_20141027_2100.dmp
log=/var/opt/oracle/log/imp_data_dodpb_20141028.log
EXPORT
buffer = 2097152
compress = n
# consistent = y
constraints = y
direct = n
feedback = 0
# feedback = 1000
# file = dodpb_daily.dmp
# full = y
full = n
grants = y
indexes = y
# log = dodpb_daily.log
owner = (phonebook, dodphonebook)
rows = y
# statistics = estimate
statistics = none
# tables = (contactdetail)
# triggers = y
triggers = n
# userid = "/ as sysdba"
userid = "thedba/********@dodpb"
^^^^^^^^ /var/opt/oracle/tmp/exp_data_dodpb_20141028_2100.par} ^^^^^^^^
DATESTAMP -- 20141028_2100
LDIR -- /usr/local/oracle
PARFILE -- /var/opt/oracle/tmp/exp_data_dodpb_20141028_2100.par
LOGDIR -- /var/opt/oracle/log
LOGFILE -- exp_data_dodpb_20141028_2100.log
EXPLOG -- /var/opt/oracle/log/exp_data_dodpb_20141028_2100.log
DMPDIR -- /opt/oracle/backup/exports/dodpb
DMPFILE -- data_dodpb_exp_20141028_2100.dmp
EXPDMP --
/opt/oracle/backup/exports/dodpb/data_dodpb_exp_20141028_2100.dmp
EXPCMD -- /opt/oracle/product/10.2.0/db_2/bin/exp
parfile=/var/opt/oracle/tmp/exp_data_dodpb_20141028_2100.par
file=/opt/oracle/backup/exports/dodpb/data_dodpb_exp_20141028_2100.dmp
log=/var/opt/oracle/log/exp_data_dodpb_20141028_2100.log