RE: timestamp refused by sql*loader

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.

--