Home » RDBMS Server » Server Utilities » SQL Loader
SQL Loader [message #70526] Tue, 25 June 2002 09:58 Go to next message
sonia
Messages: 22
Registered: March 2001
Junior Member
When I run sql loader from the command line it inserts all records successfully but it just hangs.
I get no errors but then I have to exit out of the command line to stop it.

Report message to a moderator

Re: SQL Loader [message #70527 is a reply to message #70526] Tue, 25 June 2002 10:10 Go to previous messageGo to next message
Sivakumar SG
Messages: 14
Registered: August 2000
Junior Member
Are you running from a client machine or a server. Check the free RAM in both the cases

Report message to a moderator

Re: SQL Loader [message #70529 is a reply to message #70527] Tue, 25 June 2002 11:11 Go to previous message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
im not very sure,
Make sure your ORACLE_SID env variable is set and
try to run sqlldr from the server.
so that you can invoke sqlldr traditionally like

$sqlldr scott/tiger control=loaddemo.ctl data=emp.dat

Report message to a moderator

Previous Topic: Regarding the backup
Next Topic: Export/import only those tables that contain data
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Dec 23 07:10:22 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.