OraFAQ Forum: Server Utilities » setting rollback transaction in sqlldr

Home » RDBMS Server » Server Utilities » setting rollback transaction in sqlldr

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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?

Report message to a moderator

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

Report message to a moderator

Previous Topic:	SQLLOADER Problem
Next Topic:	SQL LOADER : How to create a unique row id ?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 03:03:11 CDT 2024