Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Help - Trying to calculate rollback space needed for an update.
I am trying to calculate the amount of rollback space needed to complete an update. Ex. Table A has column ContractID defined as Varchar2(16). The average size for each record is 10 bytes. There are 5000 rows in the table. There is an index on Table A on the ContractID field. I want to update the ContractID for all 5000 rows. How do I calculate the amount of rollback space?
Thanks Received on Thu Mar 18 1999 - 07:01:16 CST
![]() |
![]() |