truncate /*+append*/

on 9ir2

say I have a table A and B. A contains 6 million records that need to be updated. This is in a data warehouse.

I want to.
truncate B.
alter table B nologging

insert /*+append*/ into B select < do update on A here>.

I understand that this will generate some redo but will it generate any UNDO? -thanx Received on Thu Mar 02 2006 - 13:43:08 CST