Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: import from 8i to 9i /IMP-00003:ORA-02298

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

From: <Surendra.Tirumala_at_mail.state.ky.us>
Date: Wed, 09 Jul 2003 07:21:27 -0700
Message-ID: <F001.005C4127.20030709071424@fatcity.com>

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 Received on Wed Jul 09 2003 - 09:21:27 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US