Return-Path: Received: from ensim.rackshack.net (root@localhost) by orafaq.net (8.11.6/8.11.6) with ESMTP id h78FRf631575 for ; Fri, 8 Aug 2003 10:27:41 -0500 X-ClientAddr: 66.27.56.210 Received: from ns3.fatcity.com (rrcs-west-66-27-56-210.biz.rr.com [66.27.56.210]) by ensim.rackshack.net (8.11.6/8.11.6) with ESMTP id h78FRep31567 for ; Fri, 8 Aug 2003 10:27:40 -0500 Received: from ns3.fatcity.com (localhost.localdomain [127.0.0.1]) by ns3.fatcity.com (8.12.5/8.12.5) with ESMTP id h78D0ODq007665 for ; Fri, 8 Aug 2003 06:04:05 -0700 Received: (from root@localhost) by ns3.fatcity.com (8.12.5/8.12.5/Submit) id h78CeMpP003308 for oracle-l@orafaq.net; Fri, 8 Aug 2003 05:40:22 -0700 Received: by fatcity.com (05-Jun-2003/v1.0g-b73/bab) via fatcity.com id 005C9A38; Fri, 08 Aug 2003 05:34:24 -0800 Message-ID: Date: Fri, 08 Aug 2003 05:34:24 -0800 To: Multiple recipients of list ORACLE-L X-Comment: Oracle RDBMS Community Forum X-Sender: Surendra.Tirumala@mail.state.ky.us Sender: ml-errors@fatcity.com Reply-To: ORACLE-L@fatcity.com Errors-To: ML-ERRORS@fatcity.com From: Surendra.Tirumala@mail.state.ky.us Subject: RE: import from 8i to 9i /IMP-00003:ORA-02298 Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 73; ListGuru (c) 1996-2003 Bruce A. Bergman Precedence: bulk Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C35DA9.65CF81A0" ------_=_NextPart_001_01C35DA9.65CF81A0 Content-Type: text/plain; charset="iso-8859-1" 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@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@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@fatcity.com' Cc: 'Surendra.Tirumala@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@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@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@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@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 ------_=_NextPart_001_01C35DA9.65CF81A0 Content-Type: text/html; charset="iso-8859-1"
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-----
From: Surendra.Tirumala@mail.state.ky.us [mailto:Surendra.Tirumala@mail.state.ky.us]
Sent: Monday, July 14, 2003 10:05 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: import from 8i to 9i /IMP-00003:ORA-02298

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@mail.state.ky.us [mailto:Surendra.Tirumala@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:
=====
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-----
From: Mercadante, Thomas F [mailto:NDATFM@labor.state.ny.us]
Sent: Wednesday, July 09, 2003 10:37 AM
To: 'ORACLE-L@fatcity.com'
Cc: 'Surendra.Tirumala@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@mail.state.ky.us [mailto:Surendra.Tirumala@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@mail.state.ky.us [mailto:Surendra.Tirumala@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@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@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-----
From: Surendra.Tirumala@mail.state.ky.us
[mailto:Surendra.Tirumala@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_01C35DA9.65CF81A0-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: Surendra.Tirumala@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@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).