Xref: alice comp.databases.oracle.misc:21063
Path: alice!news-feed.fnsi.net!newsfeed.direct.ca!Cabal.CESspool!bofh.vszbr.cz!wuff.mayn.de!news.fh-hannover.de!news.uni-stuttgart.de!news.belwue.de!News.Uni-Marburg.DE!grapool30.rz.uni-frankfurt.de!not-for-mail
From: "Mathias Dehm" <dehm@stud.uni-frankfurt.de>
Newsgroups: comp.databases.oracle.misc
Subject: Re: !! URGENT - need Help !!
Date: Sat, 10 Oct 1998 23:14:11 +0100
Organization: .
Lines: 21
Message-ID: <6vos23$1aam$1@grapool30.rz.uni-frankfurt.de>
References: <6voeok$1al6$1@grapool30.rz.uni-frankfurt.de> <361fd452.1090307@news.xs4all.nl>
X-Newsreader: Microsoft Outlook Express 4.72.3110.1
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3

Hey Martinj,

thanx for fast answering.

martinj (replace this with @) xs4all.nl wrote:
>delete from my_table my
>where my.rowid <
>(select my2.rowid
> from my_table my2
> where my2.primary_key_field = my.primary_key_field
>)


For your solution i have to know the primary key fields to build the
statemant.  The build of the primary keys are coded in the application. So i
dont know the field names of the pk :-(

I have this problem with more than 800 tables. I have to write a little
programm to generate am complete scrpit for repairing the tables.