Merge command
From: <genegurevich_at_discover.com>
Date: Wed, 9 Jan 2008 17:01:55 -0600
Message-ID: <OF3570E520.AD9D2F4C-ON862573CB.007E505B-862573CB.007E8689@discover.com>
Date: Wed, 9 Jan 2008 17:01:55 -0600
Message-ID: <OF3570E520.AD9D2F4C-ON862573CB.007E505B-862573CB.007E8689@discover.com>
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
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Jan 09 2008 - 17:01:55 CST