ORA-02294 on import
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
+--------------------------------------------------------------------+