Re: Problems with deleting tuples

Stefan Krompass wrote:
> 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
>

Hello Stefan,
maybe this is not your first delete and some deletes did actually work while this one does not?
Then you have ROWIDs in your ordered_rids table that are not valid any more. This would explain the error.
When you delete from zsimp_kopf you also have to delete the now invalid rowids from ordered_rids.

Hope that helps,

Lothar

-- 
Lothar Armbrüster       | la_at_oktagramm.de
Hauptstr. 26            | la_at_heptagramm.de
D-65346 Eltville        | lothar.armbruester_at_t-online.de