Path: news.easynews.com!easynews!nntp.flash.net!news.tele.dk!small.news.tele.dk!195.25.12.36!oleane.net!oleane!bnewspeer00.bru.ops.eu.uu.net!bnewsifeed00.bru.ops.eu.uu.net!lnewspost00.lnd.ops.eu.uu.net!emea.uu.net!not-for-mail From: "Niall Litchfield" Newsgroups: comp.databases.oracle.server References: <6f58eb57.0208080908.36f85c5c@posting.google.com> Subject: Re: Problems with deleting tuples Date: Thu, 8 Aug 2002 21:35:55 +0100 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 Lines: 28 Message-ID: <3d52d62f$0$8505$cc9e4d1f@news.dial.pipex.com> NNTP-Posting-Host: 1Cust198.tnt101.lnd4.uk.uudial.net X-Trace: 1028838959 news.dial.pipex.com 8505 213.116.50.198 X-Complaints-To: abuse@uk.uu.net Xref: easynews comp.databases.oracle.server:157299 X-Received-Date: Thu, 08 Aug 2002 13:33:03 MST (news.easynews.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. -- Niall Litchfield Oracle DBA Audit Commission UK ***************************************** Please include version and platform and SQL where applicable It makes life easier and increases the likelihood of a good answer ****************************************** "Stefan Krompaß" wrote in message news:aiuho4$d4b$00$1@news.t-online.com... > > Please read and try to understand the sentence under the first - > > It's all there! > > Just to be sure: that would mean copying the tuples from test_zsimp* to > ordered_rids? > > Stefan > >