Home » RDBMS Server » Server Utilities » SQL Loader hangs - please help
SQL Loader hangs - please help [message #368123] Tue, 08 August 2000 10:55 Go to next message
Julian
Messages: 5
Registered: August 2000
Junior Member
When I run the sqlldr80 utility on Windows NT Server 4.0 to populate an Oracle database on AIX, the utility
imports the data into the Oracle database and then hangs. I run this utility from a Delphi 4.0 application which then hangs because the sqlldr80 utility does not exit properly. Anyone else experienced a similar problem - please help!!!
Re: SQL Loader hangs - please help [message #368134 is a reply to message #368123] Wed, 30 August 2000 14:53 Go to previous messageGo to next message
Stephen Francis
Messages: 2
Registered: August 2000
Junior Member
I am seeing this problem on Windows 2000. Everytime I run SqlLdr80, after it actually commits all work, etc... it just does not return. This is a big problem for me as I'm calling it from inside of a JAVA VM... I verified it is a SQLLDR80 problem by running same at command line... it just hangs instead of cleanly exiting. Same exact tests work fine from NT - so this is a Win2000 issue. Anyone at Oracle monitor this forum?

Stephen Francis
sfrancis@avolent.com
Re: SQL Loader hangs - please help [message #368135 is a reply to message #368134] Thu, 31 August 2000 07:57 Go to previous messageGo to next message
Julian
Messages: 5
Registered: August 2000
Junior Member
Hi Steven,

I have managed to find out that the Novell client software cause sqlldr to hang, so if you are running the Novell client software on your computer it could be the problem
Re: SQL Loader hangs - please help [message #368216 is a reply to message #368134] Tue, 03 October 2000 05:48 Go to previous messageGo to next message
Pam Nicanor
Messages: 2
Registered: September 2000
Junior Member
Hi Julian. I have just read ur mail regarding SQL Loader that hangs. And I share the same problem here.
It successfully loads the data into the database however it does not exit properly. Just wondering
if you have already figured out what causes it. Can't it really be run on Windows NT Server 4.0? And
does Novell client software have something to do with this?
Thanks.
Re: SQL Loader hangs - please help [message #368217 is a reply to message #368216] Tue, 03 October 2000 09:29 Go to previous messageGo to next message
Julian
Messages: 5
Registered: August 2000
Junior Member
The Novell Client software was the cause of the problem I experienced with SQL Loader. Once I uninstalled the Novell Client software SQL Loader ran perfectly
Re: SQL Loader hangs - please help [message #368221 is a reply to message #368217] Wed, 04 October 2000 21:43 Go to previous message
Pam
Messages: 20
Registered: October 2000
Junior Member
I tried to bypass Novell Client software, however my SQL Loader still encountered "hanging". Hence, I conclude it has nothing to do with my problem. Could you please give me the version of your SQL Loader and Service Pack? Thanks.
Previous Topic: Import a binary dump - Oracle 8 from Sun to NT
Next Topic: Problem with entreprise Manager 's job
Goto Forum:
  


Current Time: Sat Apr 20 01:58:08 CDT 2024