Path: news.f.de.plusline.net!news-fra1.dfn.de!news-lei1.dfn.de!newsfeed.freenet.de!newsfeed0.kamp.net!newsfeed.kamp.net!newsfeed.stueberl.de!proxad.net!64.233.160.134.MISMATCH!postnews.google.com!l77g2000hsb.googlegroups.com!not-for-mail
From: "Carlos" <miotromailcarlos@netscape.net>
Newsgroups: comp.databases.oracle.server
Subject: Re: extracting unique fields from 2 tables into one new table
Date: 4 Apr 2007 01:36:14 -0700
Organization: http://groups.google.com
Lines: 30
Message-ID: <1175675774.277976.247500@l77g2000hsb.googlegroups.com>
References: <1175644596.475975.294310@d57g2000hsg.googlegroups.com>
NNTP-Posting-Host: 195.53.128.4
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1175675781 32627 127.0.0.1 (4 Apr 2007 08:36:21 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Wed, 4 Apr 2007 08:36:21 +0000 (UTC)
In-Reply-To: <1175644596.475975.294310@d57g2000hsg.googlegroups.com>
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; es-ES; rv:1.8.1.3) Gecko/20070309 Firefox/2.0.0.3,gzip(gfe),gzip(gfe)
Complaints-To: groups-abuse@google.com
Injection-Info: l77g2000hsb.googlegroups.com; posting-host=195.53.128.4;
   posting-account=v-zykAwAAADju6kwCHhel-_TxejVCoOK
Xref: news.f.de.plusline.net comp.databases.oracle.server:195723

On 4 abr, 01:56, "mrj" <Carl.Seppa...@gmail.com> wrote:
> Hi All,
> I'm trying to extract every unique field 'called MESSAGES' that exists
> in table LDR2 and not in table LDR into a new table UNIQUE (each table
> has only 2 fields (MESSAGES<CLOB>,ID<NUMBERIC>). We missed some data
> initially, now the LDR2 has the missing data. I need to get this
> missing data in LDR2 into the new table . However, I cant seem to run
> many commands because its a CLOB -datatypes.
>
> I'm Using SQL-PLUS - Oracle9i Release 9.2.0.1.0.
>
> <My query that doesnt seem to be working fully>
> insert into seebeyond.RAD_MESSAGES_UNIQUE (SELECT
> seebeyond.RAD_MESSAGES_LDR2.MESSAGES, seebeyond.RAD_MESSAGES_LDR2.ID
> FROM seebeyond.RAD_MESSAGES_LDR2, seebeyond.RAD_MESSAGES_LDR WHERE
> seebeyond.RAD_MESSAGES_LDR2.MESSAGES NOT LIKE
> seebeyond.RAD_MESSAGES_LDR.MESSAGES and (rownum < 33617))
> /
>
> -Thanks for any advise,
> CarlS

Why not a 'quick and dirty' MINUS?

HTH

Cheers.

Carlos.