Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Rollback segment sizing on Ora7 vs. Ora8

Re: Rollback segment sizing on Ora7 vs. Ora8

From: Anton Butanayev <butanayev_at_yahoo.com>
Date: Fri, 6 Aug 1999 08:38:43 -0500
Message-ID: <37AAE5BE.A7AF0F3C@yahoo.com>


"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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US