Re: Error while trying direct load in sql loader

From: Gareth Graham <gvgraham_at_gmail.com>
Date: Wed, 21 Sep 2011 08:24:53 -0700 (PDT)
Message-ID: <ee4e31a1-06c4-4b6c-8af9-9632c6e0a872_at_c29g2000yqd.googlegroups.com>

On Sep 21, 9:56 am, Sandy80 <svarshneym..._at_gmail.com> wrote:
> Hi,
>
> I have a table which I load through the sql loader using the following
> command:
>
> ${ORACLE_HOME}/bin/sqlldr ${DATABASE_USER}/${USER_PASS}_at_${DATABASE}
> control=${LOAD_ROOT}/ctrl/${TABLE_NAME}.ctrl data=${DATA_DIR}/$
> {TABLE_NAME}.dat log=${LOAD_ROOT}/log/${TABLE_NAME}.log bad=$
> {LOAD_ROOT}/bad/${TABLE_NAME}.bad discard=${LOAD_ROOT}/discard/$
> {TABLE_NAME}.dsd errors=100000 rows=10000  readsize=10000000
> bindsize=10000000
>
> Since this table gets more than 2.7m I wanted to improve the load
> performance and therefore tried the "direct" load on it. I try the
> direct load using the following command:
>
> ${ORACLE_HOME}/bin/sqlldr ${DATABASE_USER}/${USER_PASS}_at_${DATABASE}
> control=${LOAD_ROOT}/ctrl/${TABLE_NAME}.ctrl data=${DATA_DIR}/$
> {TABLE_NAME}.dat log=${LOAD_ROOT}/log/${TABLE_NAME}.log bad=$
> {LOAD_ROOT}/bad/${TABLE_NAME}.bad discard=${LOAD_ROOT}/discard/$
> {TABLE_NAME}.dsd errors=100000 rows=10000  readsize=10000000
> bindsize=10000000 \multithreading=true direct=true load=2000000 &
>
> As soon as I try this direct load command it gives me the following
> error for each record and rejects all of them:
>
> Record 5: Rejected - Error on table XXXXXXXXXXX.
> ORA-00604: error occurred at recursive SQL level 1
> ORA-01861: literal does not match format string
>
> Let me know if any of you have faced a similar issue and can provide
> an idea on what could be the issue.
> Any help would be appreciated. Thanks!

What Oracle version? Received on Wed Sep 21 2011 - 10:24:53 CDT