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

From: <Surendra.Tirumala_at_mail.state.ky.us>
Date: Wed, 09 Jul 2003 08:05:56 -0700
Message-ID: <F001.005C4139.20030709075924@fatcity.com>

I did that already. Please see
below..
<SPAN
class=781564614-09072003> 
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 encounteredORA-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_SYSIDfrom
cms.TWESAUwhere AU_CASELOAD_SYSID not in (select LC_CASELOAD_SYSID from cms.TWESLC);
 

No rows<SPAN
class=781564614-09072003>
 

ERROR
2:
<SPAN
class=781564614-09072003>=<SPAN
class=781564614-09072003>=====IMP-00017: following statement failed with ORACLE error 2298: "ALTER TABLE "TWESCA" ENABLE CONSTRAINT "FK_CO_CA_SYSID""IMP-00003: ORACLE error 2298 encounteredORA-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_SYSIDfrom cms.TWESCAwhere 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 AMTo: '[EMAIL PROTECTED]'Cc:
  '[EMAIL PROTECTED]'Subject: RE: import from 8i to   9i /IMP-00003:ORA-02298   

  Surendra<SPAN
  class=882492614-09072003>,
  <SPAN
  class=882492614-09072003> 
  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   

    <FONT
    face=Tahoma>-----Original Message-----From:     [EMAIL PROTECTED]
    [mailto:[EMAIL PROTECTED]Sent: Wednesday, July     09, 2003 11:14 AMTo: Multiple recipients of list     ORACLE-LSubject: 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 PMTo: Multiple recipients of list 
      ORACLE-LSubject: 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 PMTo: Multiple recipients of list 
        ORACLE-LSubject: 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 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 
        -------------------------------------------------------------------------------- 
        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] [<A 
        href="mailto:[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 

Received on Wed Jul 09 2003 - 10:05:56 CDT