ORA-02294 on import

From: <ktoepke_at_infinet.com>
Date: 1996/04/15
Message-ID: <4kulua$kcn_at_news1.infinet.com>#1/1


Hello all:

I am in the process of migrating a Oracle database from Netware to Windows NT. What's happening is I installed Oracle on the NT box, did an export on the Netware box, backed up the export file, and successfully imported to the NT box.

A few weeks later, Windows NT had to be re-installed and they blew away the Oracle database. After re-installing Oracle and restoring the export file I tried an import and got the ORA-02294: cannot add referential constraint - parent keys not found.

In an attempt to diagnose the problem, I executed the following 2 select statements and got no rows returned...
SELECT B_ID FROM A
MINUS
SELECT ID FROM B and

SELECT * FROM A
WHERE NOT EXISTS (SELECT 1
FROM B
WHERE B.ID = A.B_ID I am also getting this same error on an RS/6000 box with a different import file.

Additional Information

Netware v3.? -- Oracle v7.1.3.?.?
NT v3.51 -- Oracle v7.1.3.6.6
AIX v? -- Oracle v7.1.4.1.0

Any thoughts?

Thanks in advance.
Kevin Toepke
+--------------------------------------------------------------------+

| ktoepke_at_infinet.com        | Nothing was ever accomplished by a    |
|                            | reasonable man.                       |
|                            | -- George Bernard Shaw                |

+--------------------------------------------------------------------+
Received on Mon Apr 15 1996 - 00:00:00 CEST

Original text of this message