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

[Surendra . Tirumala]

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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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:[EMAIL PROTECTED] Sent: Wednesday, July 09, 2003 10:37 AM To: '[EMAIL PROTECTED]' Cc: '[EMAIL PROTECTED]' 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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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:[EMAIL PROTECTED] 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 >>> [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] [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