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 and import

Re: rollback segment and import

From: Harry Sheng <hsheng_at_crosskeys.com>
Date: Wed, 03 Nov 1999 15:23:00 -0500
Message-ID: <382099A4.2884483E@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 Wed Nov 03 1999 - 14:23:00 CST

Original text of this message

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