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

[Jeffrey Beckstrom]

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