Actually, it is the other way round. The default in 10g is DELETE and INSERT. --- wrote: A complete refresh in 10g does a truncate and insert append. Hemant K Chitale http://hemantoracledba.blogspot.com -- //www.freelists.org/webpage/oracle-l