Finding Columns causing errors in SQL Developer
Set the preview window higher, default is 100 rows. 



Then we can validate more during the preview.



You can scroll the preview window's worth of data, and each column value for each row will get validated via the column definition in the data.

Or, set the import type to insert script, and run the script in a worksheet.