| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: import from 8i to 9i /IMP-00003:ORA-02298
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C34A08.DA229880
Content-Type: text/plain;
charset="iso-8859-1"
Just to update you all...
I am not having any problems if I setup a db link from 9i to 8i and get the
data then enable the constraints.
Oracle asked me to create a test case for them. I have sent them all the
information they have asked for.
Thanks,
Surendra
-----Original Message-----
From: Surendra.Tirumala_at_mail.state.ky.us
[mailto:Surendra.Tirumala_at_mail.state.ky.us]
Sent: Wednesday, July 09, 2003 11:59 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: import from 8i to 9i /IMP-00003:ORA-02298
I did that already. Please see below..
ERROR 1:
ALTER TABLE CMS.TWESAU ADD CONSTRAINT FK_LC_AU_SYSID
FOREIGN KEY (AU_CASELOAD_SYSID)
REFERENCES CMS.TWESLC (LC_CASELOAD_SYSID) ON DELETE CASCADE;
Query on source database:
select AU_CASELOAD_SYSID
from cms.TWESAU
where AU_CASELOAD_SYSID not in (select LC_CASELOAD_SYSID from cms.TWESLC);
No rows
ERROR 2:
ALTER TABLE CMS.TWESCA ADD CONSTRAINT FK_CO_CA_SYSID
FOREIGN KEY (CA_COMPANY_SYSID)
REFERENCES CMS.TWESCO (CO_COMPANY_SYSID) ON DELETE CASCADE;
Query on source database:
select CA_COMPANY_SYSID
from cms.TWESCA
where CA_COMPANY_SYSID not in (select CO_COMPANY_SYSID from cms.TWESCO );
No rows.
-----Original Message-----
From: Mercadante, Thomas F [mailto:NDATFM_at_labor.state.ny.us]
Sent: Wednesday, July 09, 2003 10:37 AM
To: 'ORACLE-L_at_fatcity.com'
Cc: 'Surendra.Tirumala_at_mail.state.ky.us'
Subject: RE: import from 8i to 9i /IMP-00003:ORA-02298
Surendra,
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
-----Original Message-----
From: Surendra.Tirumala_at_mail.state.ky.us
[mailto:Surendra.Tirumala_at_mail.state.ky.us]
Sent: Wednesday, July 09, 2003 11:14 AM
To: Multiple recipients of list ORACLE-L
Subject: 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: Surendra.Tirumala_at_mail.state.ky.us
[mailto:Surendra.Tirumala_at_mail.state.ky.us]
Sent: Tuesday, July 08, 2003 5:25 PM
To: Multiple recipients of list ORACLE-L
Subject: 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:JBECKSTROM_at_gcrta.org]
Sent: Tuesday, July 08, 2003 3:59 PM
To: Multiple recipients of list ORACLE-L
Subject: 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 Beckstrom
Database Administrator
Greater Cleveland Regional Transit Authority
1240 W. 6th Street
Cleveland, Ohio 44113
(216) 781-4204
>>> Rajendra.Jamadagni_at_espn.com 7/8/03 3:34:29 PM >>>
What userid is exporting data and importing data? Try exporting and importing as system.
Raj
-----Original Message-----
From: Surendra.Tirumala_at_mail.state.ky.us
[ mailto:Surendra.Tirumala_at_mail.state.ky.us
<mailto:Surendra.Tirumala_at_mail.state.ky.us> ]
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
------_=_NextPart_001_01C34A08.DA229880
Content-Type: text/html;
charset="iso-8859-1"
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1"> <META content="MSHTML 5.50.4807.2300" name=GENERATOR></HEAD> <BODY style="MARGIN-TOP: 2px; FONT: 10pt Tahoma; MARGIN-LEFT: 2px"><DIV><SPAN class=031070513-14072003>Just to update you all...</SPAN></DIV> <DIV><SPAN class=031070513-14072003>I am not having any problems if I setup a db link from 9i to 8i and get the data then enable the constraints.</SPAN></DIV> <DIV><SPAN class=031070513-14072003>Oracle asked me to create a test case for them. I have sent them all the information they have asked for.</SPAN></DIV>
<DIV><SPAN class=031070513-14072003></SPAN> </DIV> <DIV><SPAN class=031070513-14072003>Thanks,</SPAN></DIV> <DIV><SPAN class=031070513-14072003>Surendra</SPAN></DIV> <BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px"><DIV class=OutlookMessageHeader dir=ltr align=left>-----Original Message-----<BR><B>From:</B> Surendra.Tirumala_at_mail.state.ky.us [mailto:Surendra.Tirumala_at_mail.state.ky.us]<BR><B>Sent:</B> Wednesday, July 09, 2003 11:59 AM<BR><B>To:</B> Multiple recipients of list ORACLE-L<BR><B>Subject:</B> RE: import from 8i to 9i /IMP-00003:ORA-02298<BR><BR></DIV>
<DIV><SPAN class=781564614-09072003>ERROR 1:</SPAN></DIV> <DIV><SPAN class=781564614-09072003>=====</SPAN></DIV> <DIV><SPAN class=781564614-09072003>IMP-00017: following statement failed withORACLE error 2298:<BR> "ALTER TABLE "TWESAU" ENABLE CONSTRAINT "FK_LC_AU_SYSID""<BR>IMP-00003: ORACLE error 2298 encountered<BR>ORA-02298: cannot validate (CMS.FK_LC_AU_SYSID) - parent keys not found</SPAN></DIV>
<DIV> </DIV> <DIV><SPAN class=781564614-09072003></SPAN> </DIV> <DIV><SPAN class=781564614-09072003>ALTER TABLE CMS.TWESAU ADD CONSTRAINT FK_LC_AU_SYSID<BR> FOREIGN KEY (AU_CASELOAD_SYSID) <BR> REFERENCES CMS.TWESLC (LC_CASELOAD_SYSID) ON DELETE CASCADE;</SPAN></DIV>
<DIV> </DIV> <DIV><SPAN class=781564614-09072003>Query on source database:</SPAN></DIV> <DIV><SPAN class=781564614-09072003></SPAN> </DIV> <DIV><SPAN class=781564614-09072003>select AU_CASELOAD_SYSID<BR>fromcms.TWESAU<BR>where AU_CASELOAD_SYSID not in (select LC_CASELOAD_SYSID from cms.TWESLC);</SPAN></DIV>
<DIV> </DIV> <DIV><SPAN class=781564614-09072003>Query on source database:</SPAN></DIV> <DIV><SPAN class=781564614-09072003></SPAN> </DIV> <DIV>select CA_COMPANY_SYSID<BR>from cms.TWESCA<BR>where CA_COMPANY_SYSID notin (select CO_COMPANY_SYSID from cms.TWESCO );</DIV>
<DIV> </DIV> <DIV></SPAN><SPAN class=234280015-09072003>No rows.</SPAN></DIV></DIV> <BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px"><DIV class=OutlookMessageHeader dir=ltr align=left>-----Original Message-----<BR><B>From:</B> Mercadante, Thomas F [mailto:NDATFM_at_labor.state.ny.us]<BR><B>Sent:</B> Wednesday, July 09, 2003 10:37 AM<BR><B>To:</B> 'ORACLE-L_at_fatcity.com'<BR><B>Cc:</B> 'Surendra.Tirumala_at_mail.state.ky.us'<BR><B>Subject:</B> RE: import from 8i to 9i /IMP-00003:ORA-02298<BR><BR></DIV> <DIV>
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT
face=Tahoma>-----Original Message-----<BR><B>From:</B>
Surendra.Tirumala_at_mail.state.ky.us
[mailto:Surendra.Tirumala_at_mail.state.ky.us]<BR><B>Sent:</B> Wednesday,
July 09, 2003 11:14 AM<BR><B>To:</B> Multiple recipients of list
ORACLE-L<BR><B>Subject:</B> RE: import from 8i to 9i
/IMP-00003:ORA-02298<BR><BR></FONT></DIV>
<DIV><SPAN class=062374713-09072003>I tried it on my sun box, still same
problem.</SPAN></DIV>
<DIV><SPAN class=062374713-09072003>Also I tried with no
compressing/uncompressing of dmp file, no luck.</SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left>-----Original
Message-----<BR><B>From:</B> Surendra.Tirumala_at_mail.state.ky.us
[mailto:Surendra.Tirumala_at_mail.state.ky.us]<BR><B>Sent:</B> Tuesday,
July 08, 2003 5:25 PM<BR><B>To:</B> Multiple recipients of list
ORACLE-L<BR><B>Subject:</B> RE: import from 8i to 9i
/IMP-00003:ORA-02298<BR><BR></DIV>
<DIV><SPAN class=734202220-08072003>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.</SPAN></DIV>
<DIV><SPAN class=734202220-08072003>I am wondering if the ftp(I did it
in bin mode only) from unix box to windows box caused
something?</SPAN></DIV>
<DIV><SPAN class=734202220-08072003>Anyway, I got my Sun box ready with
9i and will know soon if the problem is between Unix and
Windows.</SPAN></DIV>
<DIV><SPAN class=734202220-08072003></SPAN> </DIV>
<DIV><SPAN class=734202220-08072003>Thanks for your reply.</SPAN></DIV>
<DIV><SPAN class=734202220-08072003></SPAN> </DIV>
<DIV><SPAN class=734202220-08072003>Surendra</SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left>-----Original
Message-----<BR><B>From:</B> Jeffrey Beckstrom
[mailto:JBECKSTROM_at_gcrta.org]<BR><B>Sent:</B> Tuesday, July 08, 2003
3:59 PM<BR><B>To:</B> Multiple recipients of list
ORACLE-L<BR><B>Subject:</B> RE: import from 8i to 9i
/IMP-00003:ORA-02298<BR><BR></DIV>
<DIV>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.</DIV>
<DIV> </DIV>
<DIV>Jeffrey Beckstrom<BR>Database Administrator<BR>Greater Cleveland
Regional Transit Authority<BR>1240 W. 6th Street<BR>Cleveland, Ohio
44113<BR>(216) 781-4204<BR><BR>>>>
Rajendra.Jamadagni_at_espn.com 7/8/03 3:34:29 PM >>><BR></DIV>
<P>What userid is exporting data and importing data? Try exporting and
importing as system. </P>
<P>Raj
<BR>--------------------------------------------------------------------------------
<BR>Rajendra dot Jamadagni at nospamespn dot com <BR>All Views
expressed in this email are strictly personal. <BR>QOTD: Any clod can
have facts, having an opinion is an art ! </P><BR>
<P>-----Original Message----- <BR>From:
Surendra.Tirumala_at_mail.state.ky.us <BR>[<A
href="mailto:Surendra.Tirumala_at_mail.state.ky.us">mailto:Surendra.Tirumala_at_mail.state.ky.us</A>]
<BR>Sent: Tuesday, July 08, 2003 3:19 PM <BR>To: Multiple recipients
of list ORACLE-L <BR>Subject: RE: import from 8i to 9i
/IMP-00003:ORA-02298 </P><BR>
<P>I tried importing data first then enabling constraints, same
problem. <BR>I have disabled(it is not enabled to begin with but
reporting 'ENABLED' in <BR>USER_CONSTRAINTS) one of those constraints
Received on Mon Jul 14 2003 - 08:07:17 CDT
 |
 |