Home » RDBMS Server » Server Administration » Parents key not found (Oracle 9i,windows)
Parents key not found [message #351775] Fri, 03 October 2008 00:50 Go to next message
balaji1482
Messages: 312
Registered: July 2007
Location: INDIA
Senior Member

when i try to enable constraint ' ALTER TABLE ENABLE CONSTRAINT' i am getting this below error

'ALTER TABLE ENABLE CONSTRAINT' command failed , parent keys not found.


I have verified the parent table and child table records.There is some difference on both the tables.(records)

Please give me the solution.

Regards,
Balaji.

Re: Parents key not found [message #351777 is a reply to message #351775] Fri, 03 October 2008 00:52 Go to previous messageGo to next message
Michel Cadot
Messages: 64120
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Either:
- remove the offending rows in child table
- add parent rows
- don't enable such constraint as it seems it does not exist

Regards
Michel
Re: Parents key not found [message #351786 is a reply to message #351777] Fri, 03 October 2008 01:53 Go to previous message
balaji1482
Messages: 312
Registered: July 2007
Location: INDIA
Senior Member

Thanks michel for your information
Previous Topic: Determine which Enterprise edition specific features are in use?
Next Topic: Password file recreation
Goto Forum:
  


Current Time: Tue Dec 06 12:06:50 CST 2016

Total time taken to generate the page: 0.09971 seconds