Merge command

  • From: genegurevich@xxxxxxxxxxxx
  • To: "'oracle-l'" <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 9 Jan 2008 17:01:55 -0600

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


Other related posts: