Hi all: I am running v 10.2.0.3 and looking to using the MERGE command to load data from a flat file. Some of the rows in the flat file are new and needs to be inserted into a fact table, other - need to replace existing ones. I am planinng to have the application team load their file into a staging table via SQL*Loader and then load the data into the fact table via MERGE command. I have not used this command before; are there any issues that I should be aware of in terms of performance or bugs? thank you Gene Gurevich -- //www.freelists.org/webpage/oracle-l