I ran into this situation last month. The 'delete' option of the 'merge' statement applies to the 'when matched' only and affects the destination table. I ended up using plsql (bulk select and bulk dml) to do this work. I refered to table differecing techniques described in warehousing guide.
Thank you. -- //www.freelists.org/webpage/oracle-l
