Re: How to choose rollback segment for import

Li Chen (lichen_at_cs.buffalo.edu) wrote:
: Hi, everyone:

Hello to you too.

: 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?

Have you used the COMMIT=Y option? This is a very good option and should be used most of the time. An import mainly consists of a large number of inserts. And if you leave out the COMMIT option, import will only commit the insert towards the very end. If you have a lot of data, you will more than likely to run out of rollback segments unless you use COMMIT=Y.

If you still find yourself running out of rollback segments despite COMMIT=Y, you can try creating a very large rollback segment, and take all small rollback segments offline. This way there will only be one rollback segment - the large one. I don't think there's any other way.

Good Luck,
Leng.

--
Leng Kaing
DBA - Directory Technology P/L
Email: lkaing_at_ventnds1.telecom.com.au
Ph: +61-3-9892-9081  Fax: +61-3-9892-9344
WWW: http://www.vut.edu.au/voug