Re: Eliminating duplicates

|> In article <1994Apr19.215930.1228_at_rat.csc.calpoly.edu>, mbhatt_at_galaxy.csc.calpoly.edu (Manish J. Bhatt) writes:
|> |> Is there a way to remove duplicate records from a table? I did an
|> |> import from a backup three times, and I didn't realize that each time
|> |> it would add in another copy of a record. I can't go back to the
|> |> backup because new data has been added since then.
|> |>
|> |> Thanks,
|> |>
|> |> Manish
|> |>
|> |> ---------------------------------------------------------------------------
|> |> Manish J. Bhatt Administrative Systems
|> |> AIX Systems Administrator California Polytechnic State University
|> |> mbhatt_at_dtvrut.infsys.calpoly.edu S a n L u i s O b i s p o
I forgot something...

On soapbox:

Why aren't you using unique indexes and/or primary keys on the table to keep this from occurring?

Speed is important, but so is data integrity.

Off soapbox.

In my last post, I mentioned <cname>. That used to be in a required "for update of <cname>" clause. Oracle 7 doesn't seem to need it anymore... Received on Wed Apr 20 1994 - 23:04:30 CEST