Re: Use "SET TRANSACTION USE ROLLBACK SEGMENT" on an import ?

From: Winnie Liu <oracle_dba_at_zdnetmail.com>
Date: Mon, 12 Oct 1998 20:46:02 -0700
Message-ID: <6vui4k$969@sjx-ixn8.ix.netcom.com>

No, I don't believe you can use this statment because when Oracle perform an import, it actually involves a LOT of different transaction. Try to use commit = y and buffer size (need to look up the exact parameter, forget already!) to force ORacle to commit after a number of record (or buffer). Then you will not be running out of rollback segment that easy!

Winnie

Gerry West wrote in message <6vu05i$mbl$1_at_news1.rmi.net>...
>Hi All,
>
>Is it possible to use SET TRANSACTION USE ROLLBACK SEGMENT
>whey I perform an import.
>
>If so how ?
>
>Thanks,
>Gerry
>
>
>
Received on Mon Oct 12 1998 - 22:46:02 CDT