Re: How to set Rollback in Loader?

donnab_at_intermec.com (Donna Bigler) writes:
|> Thanks, Paul. I did know I could set the smaller RBS's offline
|> to force the large RBS to be used, but my load has to occur when
|> other users are online as well, so I was hoping for a method
|> to have them all online at the same time, but force the dataload
|> to use only the large RBS. If anyone knows of a method to do this,
|> I'd like to hear it. Otherwise I will use Paul's suggested method
|> and see what happens.
|>
|> -Donna

Assuming you are on Oracle7 since that version allows altering rollback segments offline, you could use the direct path option of SQL*Loader. It will only generate rollback information for any data dictionary changes it performs during the load.

Roderick Received on Thu Oct 26 1995 - 00:00:00 CET