Re: specifying rollback space w/SQLLDR

From: Frank van Bortel <>
Date: Fri, 06 Aug 1999 16:07:55 -0700
Message-ID: <>

Thierry Poels wrote:

Since Oracle V7.x Oracle allows you to specify an optimal size for your
rollback segments.  Rollback segments will shrink back to their optimal size
if the needed to grow before.  So if you set it up correctly EVERY rollback
segment can become very large, but will shrink back to normal size after

hope you're not running Oracle V6 anymore ;)

Thierry Poels
Oracle DBA & HP-UX sysadmin

<> wrote in message news:7oci3p$kn9$
> I am interested in finding out if anyone know how
> to specify a specific rollback segment when
> running sqlldr.  I have 10 rollback segments with
> 9 of them average sized and one very large.  I
> have 2 tables that will not load using the 9
> average sized rollback segments.  To my
> understanding, the rollback segment is selected
> based upon whatever is available.  Therefore
> hitting the large rollback segment is unlikely.
> I would appreciate any suggestions.
> Sent via
> Share what you know. Learn what you don't.

Combine that with unlimited extents, and autoextent and you can only run out of disk space...
Another option would be to take the small segments offline, start the import, and put them online again.

Met vriendelijke groet/kind regards,

Frank van Bortel
Technical consultant Oracle

Work:                                Home:
----------------------------------   ----------------------------
V&L Informatica BV                   Hunzestraat 4
Palandijn 3, 7521 PN Enschede        7555 WB Hengelo
PoBox 545, 7500 AM Enschede          (31)074-2425046
  Received on Sat Aug 07 1999 - 01:07:55 CEST

Original text of this message