Re: rollback segment and import

You mean we can use SET TRANSACTION USE ROLLBACK SEGMENT together with the imp tool ?

Could you give an example ?

Thanks.

Achim Steffes wrote:

> 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.
>
> 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 Nov 03 1999 - 14:23:00 CST