Re: REALLY private rollback segment

Hi,

    Have you tried SET TRANSACTION USE ROLLBACK SEGMENT <rbs_name>; ??

    If not issue it immediately before executing your big load. Unless this is the only job running on the system this is not guaranteed to work, but if it starts it should run to completion.

    If you must load it every night and have enough control over the usage of the system you can put Oracle into restricted mode, run the load, and then reopen Oracle to the world.

regards
jerry gitomer

borka66_at_my-deja.com wrote in message
<7tvo6s$n1$1_at_nnrp1.deja.com>...
>Hi all,
> I'm pretty sure that's impossible, but who knows...
>
> Here the story goes...
>
> I have an user that loads every night a portion of data using
>SQL*Loader. He wants the whole bulk of data commited or rolled
back.
>I've created a big rollback segment for this purpose in addition
to
>several small existent ones and changed SQL*Loader control file
to
>commit only once at end of load, but, unfortunatelly, Oracle
picks the
>rollback segment randomally and sometimes (actually almost every
time)
>the process fails due to lack of space in RBS.
> How can I force, for sure, the SQL*Loader to use the big RBS
without
>switching off all others.
>
>Thank You in advance
> Boris
>
>OS UNIX/AIX
>DB Oracle 7.3.4
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Received on Thu Oct 14 1999 - 10:14:07 CDT