Home » RDBMS Server » Server Utilities » Multiple sql loaders at a time.
Multiple sql loaders at a time. [message #71644] Mon, 09 December 2002 02:58 Go to next message
Mohamed Shameem
Messages: 3
Registered: December 2002
Junior Member
I'd greatly appreciate if someone out there could let me know how to use multiple sql loader sessions loading data into a single table simultaneously.

Report message to a moderator

Re: Multiple sql loaders at a time. [message #71646 is a reply to message #71644] Mon, 09 December 2002 12:00 Go to previous message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
That should be no problem. In Unix shell scripts you simply use an "&" to execute it in the background. You'll need separate datafiles, log files though.
sqlldr ... control=no_1.ctl ... &
sqlldr ... control=no_2.ctl ... &

Also see the "parallel" switch in sqlldr.

Report message to a moderator

Previous Topic: Hello
Next Topic: Modifying the init.ora file whilst the db is up.
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed May 15 00:10:13 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.