Re: Rollback segment sizing on Ora7 vs. Ora8

"Michael J. Loeffler" wrote:

> I have Oracle on one system, let's call it SYS1. The version of
> Oracle is 7.0.16 and it has a rollback segment size of 80M. Most of
> the things I have to do with Oracle are importing flat files using
> SQL*LOAD. Typical import size file is several hundred MB. All works
> fine, Oracle does it loads properly. Great.
>
> *NOW*
>
> I'm turning over a new system, let's call it SYS2. The version of
> Oracle is 8.0.5. I used the EXACT same database creation scripts.
> I am testing imports in SQL*LOAD using the EXACT same files that
> already work properly above in SYS1. Yet, on SYS2 - I keep running
> messages about unable to extend rollback segments. I've tried
> increasing the size of my rollback segment to 700M so far, and still
> same problem.

Mayby my answer won't be useful, but did you try importing files directly (SQL*LOADER allows it)? As far as I remember transactional mechanism isn't involved in such case and the procedure of the import goes much faster. Received on Fri Aug 06 1999 - 08:38:43 CDT