Re: Import and Rollback Segment Question

Jeremy Russell wrote:
>
> For a SQL-Import session on Oracle V7, is it possible to select a
> rollback segment to be used and thus prevent this message from
> appearing?
>
> "Error unable to extend rollback segment table import rolled back"
>
> I'm looking for something like the following command that works in
> SQL*Plus "Set transaction use rollback segment xxx"
>

Jeremy,

You can take all but your import's rbs offline as a workaround.

If rbs size is a problem you can try the COMMIT=Y import option. I think this will comit in batches and thus require less rbs but I have not tried it myself !

Mike Received on Mon Dec 09 1996 - 00:00:00 CET