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: Jeffrey Beckstrom <JBECKSTROM_at_gcrta.org>
Date: Tue, 08 Jul 2003 12:05:51 -0700
Message-ID: <F001.005C3E38.20030708115926@fatcity.com>

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 <FONT

size=2>-------------------------------------------------------------------------------- 
Rajendra dot Jamadagni at nospamespn dot com <FONT size=2>All Views expressed in this email are strictly personal. <FONT size=2>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 <FONT size=2>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 - 14:05:51 CDT

Original text of this message

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