Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Rollback question

Rollback question

From: Emrynsoft <emrynsoft_at_aol.com>
Date: 1997/05/05
Message-ID: <19970505194701.PAA25862@ladder01.news.aol.com>#1/1

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 Received on Mon May 05 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US