Re: rollback segment and import

From: Neil C <btsscrth_at_bt.com>
Date: Wed, 27 Oct 1999 15:55:47 +0100
Message-ID: <7v73pf$mmu$1@pheidippides.axion.bt.co.uk>

Hi,

unfortunately you cant do a SET TRANSACTION USE ROLLBACK SEGMENT using import

NeilC

Achim Steffes wrote in message <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.
>
>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 - 09:55:47 CDT