Re: Load data infile help
AFAIK every row in your CSV file has to have the same number of fields.
As a workaround, you might be able to open your CSV with something like Excel, then export it with NULL for the empty fields so that every row has the same number of fields, even if some are NULL.
You could then load the new file.
Good luck,
Barry.
Subject
Written By
Posted
Re: Load data infile help
May 17, 2014 02:39AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.