Home » RDBMS Server » Server Utilities » setting rollback transaction in sqlldr
setting rollback transaction in sqlldr [message #368311] Wed, 08 November 2000 16:20 Go to next message
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 Go to previous message
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
Previous Topic: SQLLOADER Problem
Next Topic: SQL LOADER : How to create a unique row id ?
Goto Forum:
  


Current Time: Thu May 19 22:48:08 CDT 2022