I tried to import a .csv file that has over 100k rows. I right clicked on Tables (and also tried right clicked on the table) and selected Import Data. It got an error "Insert failed for rows 1 through 1000 ORA-01722: Invalid number. do you want to ignore all errors?" I clicked Yes. It continued. It created the table and a .sql script with 7,874 rows. It has Row #7659 to 95000. I think the row numbers is the .csv row numbers. It got an error "IO Error: A connection attempt failed because the connected party did not properly respond after a period of time" in the middle of the script and skip about 20k rows. I ran the script then count the rows in the table. There were only over 4K.
What is the best way to import a large .csv to a table? Thanks.