RE: Duplicate rows on import

From: Storey, Robert (DCSO) <"Storey,>
Date: Tue, 5 Jan 2016 15:27:25 +0000
Message-ID: <FE4C2B093843BB4B873D754E5E0BE4DB01998C4410_at_DCSOSVMS02.dcso.org>

Hmm…I do believe that I’m changing character sets….

From: Norman Dunbar [mailto:oracle_at_dunbar-it.co.uk] Sent: Tuesday, January 05, 2016 9:24 AM To: Storey, Robert (DCSO); Oracle L
Subject: Re: Duplicate rows on import

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:27:25 CET