| Error at the time of Import [message #74167] |
Sun, 26 September 2004 21:39  |
Avra
Messages: 65
Registered: July 2004
|
Member |
|
|
Hi... I'm importing a .dmp file in Oracle8i by using imp utility... I'm doing user mode import... at the time of import I'm getting the following message... pls help me to solve this error....
Thanks....
Error:
IMP-00017: following statement failed with ORACLE error 2298:
"ALTER TABLE "TR_OPR_ENTRY" ADD CONSTRAINT "FK_OPR_LC2_NEW" FOREIGN KEY ("LC"
"") REFERENCES "CBMAST" ("LC") ON DELETE CASCADE"
IMP-00003: ORACLE error 2298 encountered
ORA-02298: cannot validate (FACMC.FK_OPR_LC2_NEW) - parent keys not found
|
|
|
|
| Re: Error at the time of Import [message #74168 is a reply to message #74167] |
Mon, 27 September 2004 02:19  |
Frank Naude
Messages: 4590
Registered: April 1998
|
Senior Member |
|
|
Hi,
Your data is inconsistent or out of step with the parent table. Fix the data in the parent table, and then recreate the constraint.
02298, 00000,"cannot validate (%s.%s) - parent keys not found"
// *Cause: an alter table validating constraint failed because the table has
// orphaned child records.
// *Action: Obvious
Best regards.
Frank
|
|
|
|
|
|
| Re: Error at the time of Import [message #74170 is a reply to message #74169] |
Mon, 27 September 2004 06:24 |
Frank Naude
Messages: 4590
Registered: April 1998
|
Senior Member |
|
|
Hi,
It is most likely a procedural mistake. Best is to export both tables with CONSISTENT=YES on the source database, then import both of them on the destination database. If you do it with CONSISTENT=YES, these tables cannot get out of sync.
Best regards.
Frank
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
