Skip to Main Content
Forums

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to import csv in SQLdev

Beauty_and_dBestAug 29 2019 — edited Aug 31 2019

12c

Hi ALL,

I am importing csv into our 12c database using Sqldeveloper.

Out of 270,000+ rows in csv, I managed to load only 187,000+

Due to a partial error below:

pastedImage_0.png

I checked the line (2,530) but I can not find any invalid format?

Or how do move cursor the specific (line,column) on the file? in Windows notepad, word or in Linux VIM?

Any tips, technics to handle this error?

Please help....

Kind regards,
This post has been answered by Beauty_and_dBest on Aug 31 2019
Jump to Answer
Comments
Post Details
Added on Aug 29 2019
#sql-developer
13 comments
367 views