Re: Duplicate rows on import

From: Norman Dunbar <oracle_at_dunbar-it.co.uk>
Date: Tue, 05 Jan 2016 15:23:40 +0000
Message-ID: <AFB40C3E-7A3C-454E-ABBC-76FAA525F16B_at_dunbar-it.co.uk>

Once, many years ago, I had a similar problem. We imported a database exp dump file from a German customer, into one with an ASCII 7 character set.

All the accented German characters got de - accented and caused duplicate rows with corresponding Primary Key constraint violations.

The problem vanished when we created a database that matched character sets.

Might be helpful?

Cheers,
Norm.
--

Sent from my Android device with K-9 Mail. Please excuse my brevity.

--

http://www.freelists.org/webpage/oracle-l Received on Tue Jan 05 2016 - 16:23:40 CET