How to choose rollback segment for import
From: Li Chen <lichen_at_cs.buffalo.edu>
Date: 1996/05/15
Message-ID: <4ndpou$aje_at_azure.acsu.buffalo.edu>#1/1
Date: 1996/05/15
Message-ID: <4ndpou$aje_at_azure.acsu.buffalo.edu>#1/1
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 consultantReceived on Wed May 15 1996 - 00:00:00 CEST