Re: data pump
From: Nigel Thomas <nigel.cl.thomas_at_googlemail.com>
Date: Fri, 5 Apr 2013 18:06:33 +0100
Message-ID: <CAGRZYUcJdHaLsxkfcyRFQ7pBv6gEU5OKD-Mok=8HXExCwG3Yeg_at_mail.gmail.com>
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.
Date: Fri, 5 Apr 2013 18:06:33 +0100
Message-ID: <CAGRZYUcJdHaLsxkfcyRFQ7pBv6gEU5OKD-Mok=8HXExCwG3Yeg_at_mail.gmail.com>
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_at_sferacarta.com> 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
>
>
>
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Apr 05 2013 - 19:06:33 CEST