Re: HELP!Import/Export

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Wed, 11 Oct 2000 09:09:31 +0100
Message-ID: <8s177v$min$1@soap.pipex.net>

Do you *already* hgave duplicate rows and not want them? Then this is an example of needing a primary key. (Or I suppose a unique constraint).

If you don't have unique rows until after the import did you drop or truncate the old table first?

HTH

--
Niall Litchfield
Oracle DBA
Audit Commission UK
"Ho" <kowho_at_singnet.com.sg> wrote in message
news:8rqgdh$cbu$4_at_coco.singnet.com.sg...


> I have performed a full export for my pc. I tried to do an import and

> I get duplicate rows in my tables. I have tried to use DESTROY=y

> option but I still get duplicate rows.

> How to avoid getting duplicate data when I do IMPORT ?

> Many thanks for your help in advance.

>

>

>

>

Received on Wed Oct 11 2000 - 03:09:31 CDT