USING THE EDITOR, CREATE A CONTROLFILE NAMES

4. Using the editor, create a controlfile names.ctl with these settings:

load datainfile 'names.txt'badfile 'names.bad'truncateinto table namesfields terminated by ','trailing nullcols(first,last)

This controlfile will truncate the target file before carrying out the insert.