So...
this still does not explain why the INSERT INTO..SELECT would generate
a
"ORA-01562: failed to extend rollback segment number 5 ORA-01628: max
#
extents (500) reached for rollback segment RBS04 "
message !
As I understand (per above postings ) that
1.. SELECT would not generate rollback but would need to use it ( for
any rows in the source table if changed )
2.. INSERT would need minimal (rowid + overhead per row) of Rollback.
The rollback segment could extend upto 500*320K = 160MB ; process
inserted ~200000 rows and got the error ; 160000000/200000=800 bytes
.
Is that being required per row for insert into a new table ??
Received on Thu Jun 27 2002 - 13:02:33 CDT
