Re: How to set Rollback in Loader?

Another way is to follow these steps:

1. Create a private rollback segment (u_segment) for the user executing load, in the tablespace where the current large rollback segment exits. Do not bring it on line.
2. From a shell startup sqlplus follow these sub-steps:
3. Bring large rollback segment offline.
4. Bring u_segment online.
5. host out to os and execute loader. when job finishes ( you may have to program this). return to sqlplus.
6. Bring u_segment offline.
7. Bring large segment online.

NOTE: This works as the 'u_segment' can only be used by this user. It

       would make admin easier if you setup a user which performs this
       loader function only.
      To bring rollback segments online/offline, you need to log on to
      sqlplus as a dba.

Hope this helps.

Vikram Goel

Sr, DBA
MOTOROLA Boynton Beach, FL

e-mail : vgoel_at_emi.net

paulb_at_pcnet.com (Paul Baumgartel) wrote:
>donnab_at_intermec.com (Donna Bigler) wrote:
>
>>We have a large rollback segment which we bring online only
>>when we do a large LOAD (from another vendor's database).
 

>>How do I set the LOADER tool to use only that RBS?
>>(Some version of 'Set Transaction use rollback ... ' that will work in loader?
 

>>MTIA
>>Donna Bigler
>
>I don't know if you can do it directly, but if you embed your loader
>commands in a file that first runs a SQL script that, after bringing
>the large RBS online, takes all of the rest (except SYSTEM, of course)
>offline, the load will have to use the large RBS. No new transactions
>will be assigned to the other segments; if they are in use when you
>issue the "offline" command, they will go offline when the
>transactions currently using them are complete. After your load,
>bring the regular segments online and the large segment offline.
>I do this every day for a large dataload and it works well.
>
>
>********************************************************************
>Paul Baumgartel, Principal Consultant paulb_at_pcnet.com
>Adept Computer Associates, Inc.
>********************************************************************
>
>
>
Received on Fri Oct 27 1995 - 00:00:00 CET