setting rollback transaction in sqlldr [message #368311] |
Wed, 08 November 2000 16:20  |
Brent Ives
Messages: 1 Registered: November 2000
|
Junior Member |
|
|
Hi,
I am trying to specify the rollback transaction to be used in SQLLDR. I want to execute multiple loads at the same time, with different rollback segments for each. Can you help?
|
|
|
Re: setting rollback transaction in sqlldr [message #368315 is a reply to message #368311] |
Thu, 09 November 2000 14:13  |
Bala
Messages: 205 Registered: November 1999
|
Senior Member |
|
|
Hi,
I don't know is it possible with sql loader.
But it is possible with utl_file package.
You can have different jobs for each load.
And 'set transaction use rollback segment'
And you can run all the jobs in parallel.
Hope this might help.
Bala
|
|
|