Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: rollback segment and import
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 Oct 27 1999 - 05:29:29 CDT