Re: LOAD DATA INFILE ERROR 1172 (42000)
Posted by: Peter Brawley
Date: November 21, 2017 01:10PM

I can't replicate the error you report. Importing the file gives ...

Query OK, 2 rows affected (0.00 sec)
Records: 2  Deleted: 0  Skipped: 0  Warnings: 0

Are there Triggers on the table?

(The table's non-primary key on regip is redundant.)



Edited 1 time(s). Last edit at 11/21/2017 01:12PM by Peter Brawley.

Options: ReplyQuote


Subject
Written By
Posted
November 20, 2017 04:46PM
Re: LOAD DATA INFILE ERROR 1172 (42000)
November 21, 2017 01:10PM


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.