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.
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.
Previous Topic: Hello
Next Topic: Modifying the init.ora file whilst the db is up.
Goto Forum:
  


Current Time: Mon Dec 23 17:04:19 CST 2024