| 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
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:
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-----
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
-----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 servicesReceived on Fri Aug 08 2003 - 08:34:24 CDT
---------------------------------------------------------------------
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).
 |
 |