Re: How to set Rollback in Loader?
Date: 1995/10/25
Message-ID: <46lrgr$f24_at_ixnews5.ix.netcom.com>#1/1
In article <DGz0A7.64r_at_intermec.com>, donnab_at_intermec.com says...
>
>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?
>
Do you really need a large RBS when using the loader? You can set the commit point using the ROWS keyword (rows per commit), on the command line or in the control file. This way, your RBS only needs to be as large as the largest set of records between commits. Also, (depending on your version of Oracle 7) there is an UNRECOVERABLE keyword that can be used for DIRECT data loads that bypass the redo logs and RBS altogether (which, BTW, runs very fast!) I also do some very large data load jobs, and have never had a RBS space problem.... Hope this helps...
- hank