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

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
Messages: 205
Registered: November 1999
Senior Member

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.
Previous Topic: SQLLOADER Problem
Next Topic: SQL LOADER : How to create a unique row id ?
Goto Forum:

Current Time: Sun May 28 01:01:28 CDT 2023