Rollback Segment usage and INSERTs?

Perhaps I'm missing something but how come Rollback Segment usage is very small or not used when inserting into a table using the normal INSERT SQL statement.

All I'm doing is doing:
INSERT INTO target_table
  SELECT * from source_table;

Testing this with 200,000 rows shows that the rollack segment stays small, initially configured to be 4MB but does not increase any furthur. If I do a DELETE or UPDATE on these tables the Rollback Segment becomes large 250Mbytes+ which is what I would expect.

Tested on 8.0.4 and 8.1.5

What am I missing?

Cheers
Simon Quinn Received on Fri Sep 24 1999 - 08:41:21 CDT