From Surendra.Tirumala@mail.state.ky.us Wed, 09 Jul 2003 07:21:27 -0700 From: Surendra.Tirumala@mail.state.ky.us Date: Wed, 09 Jul 2003 07:21:27 -0700 Subject: RE: import from 8i to 9i /IMP-00003:ORA-02298 Message-ID: MIME-Version: 1.0 Content-Type: text/plain 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 PMTo: Multiple recipients of list ORACLE-LSubject: 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 PMTo: Multiple recipients of list ORACLE-LSubject: 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 BeckstromDatabase AdministratorGreater Cleveland Regional Transit Authority1240 W. 6th StreetCleveland, 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