Re: "Seek and destroy" duplicate entries

Robert Klemme schrieb:
> 1. You can use the min(rowid) for every unique combination to delete all
> superfluous records.
>
> However, I find these approaches more attractive:
>
> 2. Use a staging table and move the data from there to the target table
> that has proper constraints with a SELECT DISTINCT or GROUP BY. (Or is
> your import table the staging table already?)
>
> 3. Filter during import to avoid duplicates during insertion (for
> example by having SQL*Loader reject records that violate constraints).
>
> Kind regards
>
> robert

Hello Robert,

thanks for your tips!
@2: The table I'm talking of ist already a staging table. @3: For various reasons there are no constraints on the staging tables defined at all.
So I stick to the rowid-method.

Thank you!
Alex Sauer Received on Mon Oct 16 2006 - 07:48:08 CDT