Re: TOAD export to MYSQL insert dups?
From: Walt <walt_askier_at_YourShoesyahoo.com>
Date: Tue, 09 Nov 2004 13:47:22 -0500
Message-ID: <_g8kd.182$i6.16_at_news.itd.umich.edu>
>
>
> yes, it turned out to be a precision problem.
> a date field was really date and time.
Date: Tue, 09 Nov 2004 13:47:22 -0500
Message-ID: <_g8kd.182$i6.16_at_news.itd.umich.edu>
Ken Handzik wrote:
>>If you have numeric data then the dump needs to show the numbers with the >>correct precision.
>
>
> yes, it turned out to be a precision problem.
> a date field was really date and time.
The Oracle Date type is always a date and a time. File that away for future reference.
> once I was sure to not lose anything along the way,
> the primary key was unique as prescribed.
You have a Date as a primary key? That's rather unfortunate.
-- //-Walt // //Received on Tue Nov 09 2004 - 19:47:22 CET