Path: news.easynews.com!easynews!cyclone.swbell.net!cyclone-sf.pbi.net!216.218.192.242!news.he.net!chekhov.conxion.net!news.oracle.com!not-for-mail
Message-ID: <3D52F550.BDDCD035@oracle.com>
From: Martin Doherty <martin.doherty@oracle.com>
Organization: Oracle Corporation
X-Mailer: Mozilla 4.75 [en] (Windows NT 5.0; U)
X-Accept-Language: en
MIME-Version: 1.0
Newsgroups: comp.databases.oracle.server
Subject: Re: Problems with deleting tuples
References: <6f58eb57.0208080908.36f85c5c@posting.google.com> <ghc5lu0ashq2l9fq32v5qsaiu7q3o9ftjm@4ax.com> <aiue80$dbp$04$1@news.t-online.com> <ugg5lug6rdofbhu000lqpreiju7roa4qod@4ax.com> <aiuho4$d4b$00$1@news.t-online.com> <3d52d62f$0$8505$cc9e4d1f@news.dial.pipex.com> <aium8f$mbk$04$1@news.t-online.com>
Content-Type: multipart/mixed;
 boundary="------------5199A71A6D3FB5A2F5FE3689"
Lines: 62
Date: Thu, 08 Aug 2002 15:48:48 -0700
NNTP-Posting-Host: 144.25.181.169
X-Trace: news.oracle.com 1028847155 144.25.181.169 (Thu, 08 Aug 2002 15:52:35 PDT)
NNTP-Posting-Date: Thu, 08 Aug 2002 15:52:35 PDT
Xref: easynews comp.databases.oracle.server:157306
X-Received-Date: Thu, 08 Aug 2002 15:47:07 MST (news.easynews.com)
--------------5199A71A6D3FB5A2F5FE3689
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

Have you tried this variation yet:

  delete from zsimp_kopf where zsimp_kopf.rowid in
    (select ordered_rids.rid from ordered_rids)

"Stefan Krompaß" " wrote:

> "Niall Litchfield" <niall.litchfield@dial.pipex.com> schrieb im Newsbeitrag
> news:3d52d62f$0$8505$cc9e4d1f@news.dial.pipex.com...
> > I'm really not sure. how do you populate your ordered rowid table? surely
> > you could just use the where clause for this population for your delete
> > statement.
>
> I've already implemented this "simple" delete:
>
>   delete from zsimp_kopf where (
>     zsimp_kopf.K2, zsimp_kopf.K3
>   ) in (
>     select test_zsimp_kopf.K2, test_zsimp_kopf.K3
>     from test_zsimp_kopf
>   )
>
> Primary key of zsimp_kopf and test_zsimp_kopf are columns K2 and K3
> (test_zsimp_kopf is just a copy of zsimp_kopf with less tuples).
> Now I wonder why
>
>   delete from zsimp_kopf where zsimp_kopf.rowid in
>     (select ordered_rids.* from ordered_rids)
>
> (with ordered_rids: "create table ordered_rids (rid rowid primary key)
> organization index") results in an error.
>
> Stefan

--------------5199A71A6D3FB5A2F5FE3689
Content-Type: text/x-vcard; charset=UTF-8;
 name="martin.doherty.vcf"
Content-Transfer-Encoding: 7bit
Content-Description: Card for Martin Doherty
Content-Disposition: attachment;
 filename="martin.doherty.vcf"

begin:vcard 
n:Doherty;Martin
tel;work:+1 650 506-8398
x-mozilla-html:FALSE
url:http://industries.oraclecorp.com
org:Oracle Corporation;Industry Solutions
version:2.1
email;internet:martin.doherty@oracle.com
title:Senior Software Specialist
adr;quoted-printable:;;Mail Stop C3038=0D=0A10 Twin Dolphin Dr=0D=0A;Redwood Shores;CA;94065;USA
fn:Martin Doherty
end:vcard

--------------5199A71A6D3FB5A2F5FE3689--