Originally posted by Mr.Hanky
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
if you dont remove the indexes and recreate them after the import what would happen to the data when trying to insert to an indexed table aside from the import going slowly?