Which database version are you using? as long as I know, at
least on Oracle 8.0.6 you can not specify which rollback segment a particular
transaction should use. We disable all rollback segments and only enable those
which we know won't make big updates / deletes crash.
-Mensaje
if I'm wrong).
Hope
this helps.
Cheers
Lee
-Original Message-From: Fermin Bernaus
[mailto:[EMAIL PROTECTED]Sent: 16 July 2003 09:09To:
Multiple recipients of list ORACLE-LSubject: RE: Rollback
Segs
Which database version are you using? as long as I know,
at least
it is to
disable all except the one we want it to use.
-Mensaje original-De: Lee Cullip
[mailto:[EMAIL PROTECTED]Enviado el: miƩrcoles, 16 de julio
de 2003 10:54Para: Multiple recipients of list
ORACLE-LAsunto: RE: Rollback Segs
set
transaction use rollback segment only
.
Cheers
Lee
-Original Message-From: Fermin Bernaus
[mailto:[EMAIL PROTECTED]Sent: 16 July 2003 11:19To:
Multiple recipients of list ORACLE-LSubject: RE: Rollback
Segs
Yes you are right, sorry but I made a mistake, since we
are using Baan IVc4 which works against Oracle we
segment, so the only way for us to do it is
to disable all except the one we want it to use.
-Mensaje original-
De: Lee Cullip [mailto:[EMAIL PROTECTED]
Enviado el: miƩrcoles, 16 de julio de 2003 10:54
Para: Multiple recipients of list ORACLE-L
Asunto: RE: Rollback Segs
set transaction use
Ave !
Is there any reason not to
keep maxextents always unlimited :) Extentsize should
be reasonable of
course.
Br.
Jorma
-Original Message-From: ext venkat Rama
[mailto:[EMAIL PROTECTED]Sent: 16 July, 2003 07:34To:
Multiple recipients of list ORACLE-LSubject: Rollback
Segs
Hi