Re: How to choose rollback segment for import

Li Chen wrote:
>
> Hi, everyone:
>
> Recently I am busy moving data across different
> instances using import/export. Some of the
> tables in database is pretty large and it
> ran out of rollback segment when the large
> table was imported.
>
> I wonder if there is a way that I can designate
> special rollback segment for import. I know
> that we can use statement "set transaction using
> rollback segment rbs_name" for a specific session.
> But is there some parameter I can set to choose
> rollback segment for import?
>
> Thanks a lot.
>
> David
>
> --
>
> David Li Chen
> Oracle DBA/Solaris SA consultant

Set the other rollback segments offline other than the one you want to use.

-- 

Muhammad A. Malik
mamalik_at_cs.wmich.edu
+1 (616) 342-4569