Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: IMPORT UTL. #1 (PK conflicted)

Re: IMPORT UTL. #1 (PK conflicted)

From: Galen Boyer <galenboyer_at_hotpop.com>
Date: 13 Aug 2001 22:47:06 -0500
Message-ID: <uelqf3zrm.fsf@verizon.net>


On 8 Aug 2001, jkyf0131_at_hotmail.com wrote:

> dear all, I am importing database from dmp file now and get
> some error msg during the process.
>
> **************************** IMP-00017: following statement
> failed with ORACLE error 2437: "ALTER TABLE

[...]

> What should I do after the import process done? Where I can
> find the information about all error which PK or other
> constrains missing? please give a hint. Thanks in advance,
>
> regards,
> JK

,----[ From http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a76999/e2100.htm#1656 ]

| ORA-02437 cannot validate (string.string) - primary key violated
|
| Cause: An attempt was made to validate a primary key with duplicate values or null values.
|
| Action: Remove the duplicates and null values before enabling a primary key.
`----

Does this tell you what you should do?

--
Galen Boyer
It seems to me, I remember every single thing I know.
Received on Mon Aug 13 2001 - 22:47:06 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US