insert into and rollback segment

[Rajesh99]

I have a huge table and I intend to do:

insert into another_table select * from big_table;

Will this run into can not extend rollback segment error?

 

[SantaMufasa]

Rajesh,

INSERT statements consume very little space (no matter how many rows you INSERT) since the ROLLBACK data that Oracle must store for in INSERT is what?...NULLs

The DML that consumes lots of space is DELETE since Oracle must store the entire row in case you want to ROLLBACK.

Mufasa
(aka Dave of Sandy, Utah, USA)
[I can provide you with low-cost, remote Database Administration services: see our website and contact me via www.dasages.com]