Allright I have a developer that is loading a few gig of historical data, that will only be used for a very short period of time. I wanted to avoid dealing with all the redo this is going to create. I created a new tablespace using the nologging option. The table and it's indexes were created with the nologging option. Yet as the developer started his load, using sqlloader, I got swamped with redo logs. The only problem this presents is that we have a standby db that is located offsite, and at times when we have heavy redo activity the archiver processes swamp our bandwidth. So no harm was really done, except I have to manually transfer all those archived logs. I am just wondering what I missed.
Thanks, Steve -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Steve McClure INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).