RE: import from 8i to 9i /IMP-00003:ORA-02298

[Mercadante, Thomas F]

Surendra,   Go back to the 8i database and run a query to see if parent records exist for all child records.  It sounds like your source database is bad.   Tom Mercadante Oracle Certified Professional -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 09, 2003 11:14 AM To: Multiple recipients of list ORACLE-L Subject: RE: import from 8i to 9i /IMP-00003:ORA-02298 I tried it on my sun box, still same problem. Also I tried with no compressing/uncompressing of dmp file, no luck. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 08, 2003 5:25 PM To: Multiple recipients of list ORACLE-L Subject: RE: import from 8i to 9i /IMP-00003:ORA-02298 With all my today's trials(including import into 8i db on Sun) I used different export file than the one I have used other day. I am wondering if the ftp(I did it in bin mode only) from unix box to windows box caused something? Anyway, I got my Sun box ready with 9i and will know soon if the problem is between Unix and Windows.   Thanks for your reply.   Surendra -----Original Message----- From: Jeffrey Beckstrom [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 08, 2003 3:59 PM To: Multiple recipients of list ORACLE-L Subject: RE: import from 8i to 9i /IMP-00003:ORA-02298 Could your export file be corrupt.  There have been a few alerts on 8.1.7 exports producing bad dump files.  One alert is Note:223399.1.   Jeffrey Beckstrom Database Administrator Greater Cleveland Regional Transit Authority 1240 W. 6th Street Cleveland, Ohio 44113 (216) 781-4204 >>> [EMAIL PROTECTED] 7/8/03 3:34:29 PM >>> What userid is exporting data and importing data? Try exporting and importing as system. Raj -------------------------------------------------------------------------------- Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 08, 2003 3:19 PM To: Multiple recipients of list ORACLE-L Subject: RE: import from 8i to 9i /IMP-00003:ORA-02298 I tried importing data first then enabling constraints, same problem. I have disabled(it is not enabled to begin with but reporting 'ENABLED' in USER_CONSTRAINTS) one of those constraints and tried to enable it manually. Same error. And I have checked the data again. It is having parent keys. Thanks, Surendra