Path: news.easynews.com!easynews!feedwest.aleron.net!aleron.net!sfo2-feed1.news.algx.net!allegiance!logbridge.uoregon.edu!kibo.news.demon.net!demon!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!newsmm00.sul.t-online.com!t-online.de!news.t-online.com!not-for-mail From: "Stefan Krompaß" Newsgroups: comp.databases.oracle.server Subject: Re: Problems with deleting tuples Date: Thu, 8 Aug 2002 23:01:54 +0200 Organization: T-Online Lines: 30 Message-ID: References: <6f58eb57.0208080908.36f85c5c@posting.google.com> <3d52d62f$0$8505$cc9e4d1f@news.dial.pipex.com> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Trace: news.t-online.com 1028840527 04 22900 bVAib0PVSJDczi 020808 21:02:07 X-Complaints-To: abuse@t-online.com X-Sender: 520098957347-0001@t-dialin.net User-Agent: Hamster/1.3.23.4 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 Xref: easynews comp.databases.oracle.server:157303 X-Received-Date: Thu, 08 Aug 2002 14:01:05 MST (news.easynews.com) "Niall Litchfield" 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