Re: Data import problem.

From: Andrew Babb <andrewb_at_mail.com>
Date: Thu, 08 Apr 1999 16:02:54 +0800
Message-ID: <370C62AE.D1929209@mail.com>

It sounds as though you are getting an Oracle Error 00001 - Duplicate Key in Index for table2.

If you are wanting to violate the Primary Key, you can convert the index to nonunique, and loose the PK on table2, otherwise, you will not be able to perform the import of these rows, since there is no way of directly interfering with data coming in from the dmp file.

Having said this, you could try and put a before insert trigger on table2, which allocates a new ID, if that is what you are wanting.

Andrew

Svetlana Pelesheva wrote:

> Hi,
> We have two Oracle tables with exactly the same structure and it is
> necessary to import data of table1 into table 2. Import puts into table2
> all the new records from table1. But if record's ID from table1 is equal
> ID from table2 it doesn't make update for these records. Help!
>
> Thanks forward.
Received on Thu Apr 08 1999 - 03:02:54 CDT