Home » RDBMS Server » Server Utilities » SQL*loader error when using DIRECT=TRUE
SQL*loader error when using DIRECT=TRUE [message #71391] Fri, 25 October 2002 09:26 Go to next message
Simon
Messages: 60
Registered: December 1998
Member
Hi,
I have two files which I wish to load into a newly created temporary Oracle table. They are run within a for loop from an HP-UX shell script

Using the following command

sqlldr USERID=/ CONTROL=blah.ctl LOG=blah.log DATA=blah.mid DIRECT=TRUE

The first file is loaded successfully into the table however the second file receives the following error message(s)

Error during upi fetch
ORA-3106 fatal two task communication protocol error
SQL*Loader-704 Internal error: uldisconnect

Does anyone have any ideas??

Cheers
Re: SQL*loader error when using DIRECT=TRUE [message #71392 is a reply to message #71391] Fri, 25 October 2002 09:34 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
set the initparmeter SESSION_CACHED_CURSORS to zero.
togggle the database.
try the sqlldr again
Previous Topic: How to do import and export?
Next Topic: imp for rank
Goto Forum:
  


Current Time: Wed May 15 11:15:48 CDT 2024