Jo See also the first answer in http://stackoverflow.com/questions/3308518/convert-date-from-one-format-to-another-using-sqlloader-control-file; There's a lot you can do from the control file! See also http://docs.oracle.com/cd/B28359_01/server.111/b28319/ldr_field_list.htm#i1008150 - skip down to the section on dates. You might also want to read about how to load multiple tables from the same data file: http://docs.oracle.com/cd/E11882_01/server.112/e16536/ldr_control_file.htm#autoId72 HTH Nigel On 5 April 2013 15:48, jo <jose.soares@xxxxxxxxxxxxxx> wrote: > SQL*Load is great, it uploads an entire database in a few minutes. > Faster than Postgres. > But I'm yet fighting with dates style. > I need to insert dates with iso style yyyy-mm-dd but oracle wants it in > the format dd-mon-yy > > > > > -- //www.freelists.org/webpage/oracle-l