Re: rollback segment and import

From: Eugene Firyago <efiryago_at_bisys.com>
Date: Wed, 27 Oct 1999 09:15:35 -0400
Message-ID: <7v6tuo$115$1@autumn.news.rcn.net>

Achim Steffes <achim.steffes_at_rhein-main.net> wrote in message news:3816D409.2063A51_at_rhein-main.net...
> Hi Thomas,
>
> as NeilC mentioned, you have to make sure that there is rollbacksegment,
> thats large enough for your transaction
> and enter the following command SET TRANSACTION USE ROLLBACK SEGMENT
> rollbacksegmentname.

This instruction is not available within import utility... See imp help=y for more details.

>
> I hope that helps
>
> Bye Achim
>
> Thomas Jork schrieb:
>
> > hi folks
> >
> > i want to import a database, but my rollback segments are to small for
> > some of the tables.
> > how can i make oracle use a special big rollback segment for this
> > special task? or is there any
> > other solution.
> >
> > thanks in advance
> >
> > thomas
>
Received on Wed Oct 27 1999 - 08:15:35 CDT