How to specify a large rollback segment for a SQL*Loader session?
If you are loading huge data by SQL* Loader then you might get rollback segment errors. You can avoid these errors by specifying a large rollback segment for the SQL*Loader session. Here are few steps to do it. 1. Query DBA_ROLLBACK_SEGS to see if the segments are online or offline. Under the Status column, OFFLINE is ‘available’, and ONLINE is ‘in use’. SQL> Select SEGMENT_NAME, TABLESPACE_NAME, STATUS from DBA_ROLLBACK_SEGS; 2. Create a very large Rollback Segment. SQL> Create rollback segment verybig tablespace rollback_data storage (initial 1M next 1M minextents 2 maxextents 512); Rollback segment created. 3. Bring new Rollback Segment (verybig) online. SQL> Alter rollback segment verybig online; Rollback segment altered. 4. Take all other Rollback Segments except SYSTEM rollback segment offline. Note: You cannot take the SYSTEM rollback segment offline. SQL> Alter rollback segment RBS1 offline; Rollback segment altered. Repeat above command for all other rollback segments, except
