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

From: <Surendra.Tirumala_at_mail.state.ky.us>
Date: Tue, 08 Jul 2003 13:41:21 -0700
Message-ID: <F001.005C3E5A.20030708132432@fatcity.com>

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]   [<A
  href="mailto:[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 Received on Tue Jul 08 2003 - 15:41:21 CDT