Re: How does Oracle select rollback segments?

You need either to issue
set transaction use rollback segment <xyz> or alter (all the ) rollback segment offline (you don't want)

Hth,

Sybrand Bakker, Oracle DBA

Alessandro Bonetti <abonetti_at_yahoo.com> wrote in message news:sGnr3.2307$001.1120861_at_WReNphoon3...
> Hi,
> I've a Delphi program that uses a large table (100,000 records and more).
So
> I created a large rollback segment with its own name. Consider in Delphi
is
> not possible to start a transaction using a specific rollback segment. So,
> every time I run my program I obtain a rollback overflow error. How do
> Personal Oracle 7.3 select rollback segments? How can I force my Delphi
> program to use a specific rollback segment or how can I configure rollback
> segment to be used by my program?
> Thanx.
> Bombi
>
>
>
> -**** Posted from RemarQ, http://www.remarq.com/?b ****-
> Real Discussions for Real People
Received on Sun Aug 08 1999 - 23:56:37 CDT