From oracle-l-bounce@freelists.org Thu Sep 29 16:33:53 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j8TLXrL3023431 for ; Thu, 29 Sep 2005 16:33:53 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j8TLXn6H023409 for ; Thu, 29 Sep 2005 16:33:49 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 03A341EF3E6; Thu, 29 Sep 2005 16:33:37 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 12202-08; Thu, 29 Sep 2005 16:33:36 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 7661B1EFE9B; Thu, 29 Sep 2005 16:33:36 -0500 (EST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:references; b=aJl2IkFGglEJa1kQHlyl1bknPE54krdTv9Or2RA4u6xFi6fRgAHTM93zvdCsBEjuSy5KPYK6jrE0lPjcyArmdVpgjSgBdIPR4ZkR5NB+eOG9FptCeT4t8wrf1QOr/KeeeqZQXQxkyuThyqNFkpRpol/UryF3SPVpNORwiABCaGU= Message-ID: Date: Thu, 29 Sep 2005 14:31:42 -0700 From: Jared Still To: ranko.mosic@gmail.com Subject: Re: Dimension table load - PLSQL question Cc: Paul Drake , ORACLE-L In-Reply-To: <367369f105092905453d434c39@mail.gmail.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_597_20255613.1128029502187" References: <367369f1050928150337fdbc5e@mail.gmail.com> <910046b4050928152964ea0f78@mail.gmail.com> <367369f105092905453d434c39@mail.gmail.com> X-archive-position: 26132 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: jkstill@gmail.com Precedence: normal Reply-To: jkstill@gmail.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=-3.6 required=5.0 tests=AWL,BAYES_00,HTML_MESSAGE autolearn=ham version=2.63 ------=_Part_597_20255613.1128029502187 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline On 9/29/05, Ranko Mosic wrote: > > Thanks for very helpful, no patronizing answer. If you've read more > carefully what the problem is > you'd see that MERGE can't work because it works on one table upserting > another. > I have one table being inserted from 6 tables. > Thanks genius. > > Some of the more talented and prolific folks on this list are prone to use kill files to filter out email from addresses they would prefer to ignore. (Paul is one of them BTW) Replies such as this one are a near guarantee that some of your potential responders will no longer see your posts. -- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist ------=_Part_597_20255613.1128029502187 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline On 9/29/05, Ranko Mosic <ranko.mosic@gmail.com> wrote:
Thanks for very helpful, no patronizing answer. If you've read more ca= refully what the problem is
you'd see that MERGE can't work because it works on one table upsertin= g another.
I have one table being inserted from 6 tables.
Thanks genius.


Some of the more talented and prolific folks on this list are
prone to use kill files to filter out email from addresses they
would prefer to ignore. (Paul is one of them BTW)

Replies such as this one are a near guarantee that some of
your potential responders will no longer see your posts.

--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangel= ist
------=_Part_597_20255613.1128029502187-- -- http://www.freelists.org/webpage/oracle-l