Re: Load Data Local Infile not Working
On further investigation, I've found more errors.
Your table has no PRIMARY KEY specified.
Some rows are missing data for some fields.
The copy I took of your data had no tabs '\t' when I copy\paste into my text editor.
When I fixed that (which may not be your fault!) the data does load, but with errors for missing fields.
You'll need to fix your column count, and your PRIMARY INDEX.
Good luck,
Barry.
Subject
Written By
Posted
Re: Load Data Local Infile not Working
October 03, 2022 07:08PM
Sorry, only registered users may post in this forum.
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.