Re: rollback segment and import

In case you can manage to take the smaller rbs offline , try that. keep the big one online only.

good luck.
-- Mukul

Harry Sheng <hsheng_at_crosskeys.com> wrote in message news:382099A4.2884483E_at_crosskeys.com...
> 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 Thu Nov 04 1999 - 15:38:39 CST