Re: TOAD export to MYSQL insert dups?

Ken Handzik (kmh_at_excaliburinc.com) wrote:
: The only useful response I have found so far came from another site.

: Someone pointed out that Primary keys in Oracle are not automatically
: Unique.

That is wrong.

Perhaps the other person got confused when they examined the syntax diagram of the statements involved. Oracle does not require a keyword such as "unique" on a primary key definition, but that is just the syntax of the statement. The primary key is always unique (and unlike some systems, also cannot include any nulls).

Since you have it in a text file, why don't you just examine the data directly? Your favourite editor, or sort/awk/grep, or a few perl one-liners should tell you everything you need to know about the extracted data.

If the extracted primary key includes duplicated data then I would suspect that one of the tools used along the way to extract the data has been asked to do the wrong thing, or you misunderstand something else about the data.

Perhaps the oracle primary key uses a number of columns and the mysql index is/are not defined correctly to include all those columns.

[Quoted] If you have numeric data then the dump needs to show the numbers with the correct precision.

If you have character data then perhaps the dump configuration needs to consider things such as the character set of the strings. Received on Mon Nov 01 2004 - 19:52:34 CET