Re: Merge command

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Thu, 10 Jan 2008 07:13:45 -0000
Message-ID: <017301c85358$56e7abf0$0200a8c0@Primary>

If you have any uniqueness constraints on the table then you need to be sure that the merge command will not try to break those constraints, or the whole merge will fail and rollback.

The obvious example is where you might have two rows with the same primary key in the flat file that needs to be inserted - but if you have other unique keys declared the problem becomes a little more awkward.

Regards

Jonathan Lewis
http://jonathanlewis.wordpress.com

Author: Cost Based Oracle: Fundamentals
http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

  • Original Message ----- From: <genegurevich_at_discover.com> To: "'oracle-l'" <oracle-l_at_freelists.org> Sent: Wednesday, January 09, 2008 11:01 PM Subject: Merge command

> 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-l
>
>
>
>
> --
> No virus found in this incoming message.
> Checked by AVG Free Edition.
> Version: 7.5.516 / Virus Database: 269.17.13/1214 - Release Date: 08/01/2008
> 13:38
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Jan 10 2008 - 01:13:45 CST

Original text of this message