Groups
Sign in
Groups
comp.databases.oracle.misc
Conversations
About
Send feedback
Help
info
Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Learn more
Error while trying direct load in sql loader
151 views
Skip to first unread message
Sandy80
unread,
Sep 21, 2011, 4:56:28 AM
9/21/11
Delete
You do not have permission to delete messages in this group
Copy link
Report message
Sign in to report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
to
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!
Gareth Graham
unread,
Sep 21, 2011, 11:24:53 AM
9/21/11
Delete
You do not have permission to delete messages in this group
Copy link
Report message
Sign in to report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
to
What Oracle version?
joel garry
unread,
Sep 21, 2011, 12:21:22 PM
9/21/11
Delete
You do not have permission to delete messages in this group
Copy link
Report message
Sign in to report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
to
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/2011/sep/20/10000-city-grant-went-to-praise-fest/
0 new messages