Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: IMPORT UTL. #1 (PK conflicted)
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