Hi,

I have a table which I load through the sql loader using the following
command:

${ORACLE_HOME}/bin/sqlldr ${DATABASE_USER}/${USER_PASS}@${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}@${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!

On Sep 21, 9:56*am, Sandy80 <svarshneym... (AT) gmail (DOT) com> wrote:
What Oracle version?

On Sep 21, 1:56*am, Sandy80 <svarshneym... (AT) gmail (DOT) com> wrote:
I haven't, but see MOS Sqlloader Fails With ORA-604 And ORA-1861 When
Loading Date Fields And Using Direct=Y [ID 780525.1]

jg
--
@home.com is bogus.
http://www.signonsandiego.com/news/2...o-praise-fest/