Re: Rollback question

On 5 May 1997 19:48:10 GMT, emrynsoft_at_aol.com (Emrynsoft) wrote:

>We have a situation where we are doing a insert into table1 as select *
>from table2. The size of table1 when created added with its index size is
>about 600M. When doing the insert it is generating almost 1.4gigs of
>rollback space. I thought that inserts were the least rollback intensive,
>so why is it taking so much rollback space.
>
>Any insights would be appreciated.
>
>Thanks,
>Abhijit

How many indexes are on the table? This would explain such a large rollback, also, look at what your next extents? It may be that it is growing to that size because they are sized improperly. If it is the indexes, drop during the insert, the recreate indexes. If the rollback extent size, resize and try again.

Sheilah Scheurich
DBA
scheuric_at_sprynet.com Received on Tue May 06 1997 - 00:00:00 CDT