Home » RDBMS Server » Server Utilities » SQL Loader (Oracle 9.2.0.1.0, Windows 2003 Server)
SQL Loader [message #361112] Tue, 25 November 2008 01:43 Go to next message
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 259 times)
Re: SQL Loader [message #361115 is a reply to message #361112] Tue, 25 November 2008 01:45 Go to previous messageGo to next message
mail2das.ashok
Messages: 10
Registered: May 2008
Junior Member
Hi,

ORA-03113: end-of-file on communication channel

This indicates u might have lost the connection.
Re: SQL Loader [message #361116 is a reply to message #361112] Tue, 25 November 2008 01:45 Go to previous messageGo to next message
Michel Cadot
Messages: 58938
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-00600/ORA-07445/ORA-03113 = Oracle bug => search on Metalink and/or call Oracle support

Regards
Michel
Re: SQL Loader [message #361239 is a reply to message #361112] Tue, 25 November 2008 08:23 Go to previous messageGo to next message
joy_division
Messages: 4504
Registered: February 2005
Location: East Coast USA
Senior Member
Does the table have a LONG column?
You may need to load with ROWS=1 parameter.
Re: SQL Loader [message #361245 is a reply to message #361239] Tue, 25 November 2008 09:05 Go to previous messageGo to next message
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 Go to previous messageGo to next message
joy_division
Messages: 4504
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 Go to previous message
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.
Previous Topic: Not able to load data to the table using SQL Loader utility
Next Topic: Importing dump to Oracle10g-win from exportdump 9i-linux
Goto Forum:
  


Current Time: Sat Aug 30 03:56:24 CDT 2014

Total time taken to generate the page: 0.05747 seconds