I would create a parfile not a sql file.


file=exp_scott.dmp
log=imp_scott.log
userid=system (Never put a password in a parfile!!)
fromuser=scott
touser=?????
tables=(emp,dept)
indexes=n
ignore=y
Buffer=4000000
commit=y

The buffer and commit are only used for large tables, if you are dealing with small tables you don't really need it.


MH