SQL Loader [message #361112] |
Tue, 25 November 2008 01:43 |
skmmmf
Messages: 10 Registered: November 2008
|
Junior Member |
|
|
Hi All,
I am importing data from a flat file to a table (without constraint) through sql loader using Direct Path method.
While importing, I am getting the following error :
(This works fine when I use Conventional Path method.
If I take that particular 17904 row as a seperate file & try to import, it works fine.)
Record 17904: Rejected - Error on table GWCIF_TMP.
ORA-03113: end-of-file on communication channel
SQL*Loader-926: OCI error while uldlfca:OCIDirPathColArrayLoadStream for table GWCIF_TMP
SQL*Loader-2026: the load was aborted because SQL Loader cannot continue.
SQL*Loader-925: Error while uldlgs: OCIStmtExecute (ptc_hp)
ORA-03114: not connected to ORACLE
SQL*Loader-925: Error while uldlgs: OCIStmtFetch (ptc_hp)
ORA-24338: statement handle not executed
Can anyone help me to fix this problem? (Log file has been attached for reference)
-
Attachment: log.txt
(Size: 6.77KB, Downloaded 1927 times)
|
|
|
|
|
|
Re: SQL Loader [message #361245 is a reply to message #361239] |
Tue, 25 November 2008 09:05 |
skmmmf
Messages: 10 Registered: November 2008
|
Junior Member |
|
|
Hi Joy,
It doesnt have any Long datatype.
thank you Joy. It works fine with ROWS=1 or ROWS=100. Can you tell me the reason why it raises error when we omit the ROWS parameter?
|
|
|
Re: SQL Loader [message #361291 is a reply to message #361245] |
Tue, 25 November 2008 13:00 |
joy_division
Messages: 4963 Registered: February 2005 Location: East Coast USA
|
Senior Member |
|
|
Not really. Maybe there is a trigger on the table causing problems when it loads rows with a buffer rather than one at a time.
|
|
|
Re: SQL Loader [message #362100 is a reply to message #361112] |
Sun, 30 November 2008 22:35 |
skmmmf
Messages: 10 Registered: November 2008
|
Junior Member |
|
|
But there is no Triggers, constraints or indexes on that table. Anyway thank you joy for helping me to fix that problem. If you knew the reason, pls. share it with me.
|
|
|