Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Problems with deleting tuples

Re: Problems with deleting tuples

From: Stefan Krompass <krompass_at_fmi.uni-passau.de>
Date: 8 Aug 2002 23:40:48 -0700
Message-ID: <6f58eb57.0208082240.6aa4cc95@posting.google.com> 





Martin Doherty <martin.doherty_at_oracle.com> wrote in message news:<3D52F550.BDDCD035_at_oracle.com>...


> Have you tried this variation yet:

> 

>   delete from zsimp_kopf where zsimp_kopf.rowid in

>     (select ordered_rids.rid from ordered_rids)




Yes, I did: 



SQL> delete from zsimp_kopf where zsimp_kopf.rowid in


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


            *


ERROR at line 1:


ORA-01410: invalid ROWID



Stefan
Received on Fri Aug 09 2002 - 01:40:48 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US