Re: timestamp refused by sql*loader

From: Jose Soares Da Silva <jose.soares_at_sferacarta.com>
Date: Tue, 15 Sep 2015 12:47:53 +0200
Message-ID: <55F7F759.7020403_at_sferacarta.com>

I did as you said... changing the order of the rows it works. ... but I didn't understand why.

j

On 15/09/2015 12:11, Jonathan Lewis wrote:
> No,
>
> In your first post you said you changed the values in an existing line, you did NOT say that you swapped the two lines over.
>
> When Oracle appears to be doing something that seems to be unexpected or unreasonable it is very important to be very careful in the description of what you have done. Even to the extent that "changing every row to a specific date" could give misleading results if the method you used to change the data is ":s/2005-.*$/{something else}" rather than overwriting 5 characters which are the mm-dd bit.
>
> Following up Dominic's suggestion that you're seeing unpredictable (to us) behaviour because of the incomplete specification, you could try enabling SQL Trace for the session to see what SQL statement the loader is parsing when loading your data - this might give use some clue about what's happening.
>
>
>
> Regards
> Jonathan Lewis
> http://jonathanlewis.wordpress.com
> _at_jloracle
>
> ________________________________________
> From: Jose Soares Da Silva [jose.soares_at_sferacarta.com]
> Sent: 15 September 2015 10:39
> To: Jonathan Lewis; oracle-l_at_freelists.org
> Subject: Re: timestamp refused by sql*loader
>
> If I swap the lines it works as I explained in my first post
> I change all values to 2009-07-08 00:00:00 in all lines (abt 14000) and
> all of them were loaded.
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Sep 15 2015 - 12:47:53 CEST