Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Remove duplicates
My suggestion would be to put a primary key on the table (the primary key being what makes each record unique), and let import reject the duplicates.
JIK
xiaomh wrote:
>
>
> I want to import 10000 entries to my database. There are some duplicates
in
> them.
>
> What's the best way to remove them(duplicates)?
>
> Thanks in advance!
>
>
-- Posted via CNET Help.com http://www.help.com/Received on Mon Mar 12 2001 - 21:30:12 CST
![]() |
![]() |