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: Fri, 08 Aug 2003 05:34:24 -0800
Message-ID: <F001.005C9A38.20030808053424@fatcity.com>


Update...  

Oracle filed a bug (#3083916) to resolve this and they suggested a workaround for the time being..
We have function based indexes on the associated PKs and dropping those indexes letting us enable the constraints.

-----Original Message-----

[mailto:Surendra.Tirumala_at_mail.state.ky.us] Sent: Monday, July 14, 2003 10:05 AM
To: Multiple recipients of list ORACLE-L

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

[mailto:Surendra.Tirumala_at_mail.state.ky.us] Sent: Wednesday, July 09, 2003 11:59 AM
To: Multiple recipients of list ORACLE-L

I did that already. Please see below..  

ERROR 1:



IMP-00017: following statement failed with ORACLE error 2298:  "ALTER TABLE "TWESAU" ENABLE CONSTRAINT "FK_LC_AU_SYSID"" IMP-00003: ORACLE error 2298 encountered ORA-02298: cannot validate (CMS.FK_LC_AU_SYSID) - parent keys not found    

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:



IMP-00017: following statement failed with ORACLE error 2298:  "ALTER TABLE "TWESCA" ENABLE CONSTRAINT "FK_CO_CA_SYSID"" IMP-00003: ORACLE error 2298 encountered ORA-02298: cannot validate (CMS.FK_CO_CA_SYSID) - parent keys not found  

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

Sent: Wednesday, July 09, 2003 10:37 AM
To: 'ORACLE-L_at_fatcity.com'
Cc: 'Surendra.Tirumala_at_mail.state.ky.us'

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

[mailto:Surendra.Tirumala_at_mail.state.ky.us] Sent: Wednesday, July 09, 2003 11:14 AM
To: Multiple recipients of list ORACLE-L

I tried it on my sun box, still same problem. Also I tried with no compressing/uncompressing of dmp file, no luck.

-----Original Message-----

[mailto:Surendra.Tirumala_at_mail.state.ky.us] Sent: Tuesday, July 08, 2003 5:25 PM
To: Multiple recipients of list ORACLE-L

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

Sent: Tuesday, July 08, 2003 3:59 PM
To: Multiple recipients of list ORACLE-L

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




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

[ 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

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

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: Surendra.Tirumala_at_mail.state.ky.us

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services

---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Received on Fri Aug 08 2003 - 08:34:24 CDT

Original text of this message

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