You are here:

Oracle/import problem

Advertisement


Question
my operating system is win xp.and oracle version is 10g.
when i import updated dmp file but not update.show the following problems:

   1.IMP00019: row rejected due to ORACLE error1.
    IMP0003:ORACLE error 1 encountered
    0001:unique constraint (sysMAN.MGMI_ARU_PRD_PK) violated..............

Answer
Hi Fahmida,

The problem that you are encountering is you are attempting to import a row of data that is causing the Primary Key (PK) index, sysMAN.MGMI_ARU_PRD_PK to fail. As it is a PK, it is expecting unique values.

It is possible the DMP file for this table contained a duplicate entry. You may wish to consult with the provider of the DMP file, and take a look at the source table(s) where it came from.

I usually would not recommend disabling constraints (in your case dropping your index) just to update your table. There's a reason for the constraint.

Other option that you may have is to import the DMP file to a temporary table and compare the results with the intended table to update to spot any duplications.

I hope this helps.

Peter

Oracle

All Answers


Answers by Expert:


Ask Experts

Volunteer


Peter Choi

Expertise

I am a senior Oracle DBA, PeopleSoft HCM specialist and Project Manager with 15+ years experience. I have been working with PeopleSoft (HRMS/HCM 5, 7, 7.x and 8.9, 9.x), Oracle RDBMS (7.3 - 11gR2) on various Unix and MS-Windows platforms, and some Oracle Application Server (9i - 11gR1). I also have experience with the configuration and administration of PeopleSoft's Internet Architecture (PIA) and the Oracle 11g Fusion Middleware and Oracle Business Intelligence (OBI).

©2016 About.com. All rights reserved.