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

Surendra<SPAN
class=882492614-09072003>,
<SPAN
class=882492614-09072003> 
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

  <FONT
  face=Tahoma>-----Original Message-----From:
[EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]Sent: Wednesday, July
  09, 2003 11:14 AMTo: Multiple recipients of list   ORACLE-LSubject: 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 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] 
      [<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