overflow. The rollback segment is where
the old values of the data you modify (here the column C536870975)
are saved, just in case you end your
transaction with a ROLLBACK instead of
a COMMIT (and for other purposes).
If you modify a lot of data, there simply
will not be enough space in the rollback
segment to save the old values.
Increase the size of the rollback
segment by adding more datafiles
(ask your DBA).
Also, look in the Admin 2 manual
(or the installation? I don't remember)
to see how to specify a dedicated
rollback segment
for all your ARS transaction.
HTH
Alberto
--
On Wed, 19 Jan 2000 14:16:27 lars.pettersson wrote:
>Hi, anyone who knows what is to think about before running this sql command.
>I have noticed messages about tmp segment/rollbacksegment ? sometimes, our
>DBA have then done something, after that ok.
>
>UPDATE T133 SET C536870975 = $Ange faktureringsdatum$ WHERE C536870945 = 0
>AND C7 = 0 AND C536870987 >0
>
>Suppose a copy is taken of the data in the form, and if not enough space
>then the command will not execute. is that right ?
>
>DB: Oracle.
>
>I just want to enter a value in a field, so push fields or modify all is not
>good to use, I don't want to spend hours...but with direct sql it takes no
>time.
>About 50000 entries.
>
>Thanks, L ars
>
>
>To Unsubscribe send e-mail to:
>body of text is: unsubscribe arslist
>
--== Sent via Deja.com http://www.deja.com/ ==--
Share what you know. Learn what you don't.
To Unsubscribe send e-mail to:
body of text is: unsubscribe arslist
Previous Topic
Index