Re: specifying rollback space w/SQLLDR

Hi,

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
usage.

hope you're not running Oracle V6 anymore ;)

greetings,
Thierry Poels
Oracle DBA & HP-UX sysadmin

<kcmarrs_at_my-deja.com> wrote in message news:7oci3p$kn9$1_at_nnrp1.deja.com...
> 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 Deja.com http://www.deja.com/
> 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
053-4341500
  Received on Sat Aug 07 1999 - 01:07:55 CEST