Home » RDBMS Server » Server Administration » URGENT PLEASE
URGENT PLEASE [message #53440] Thu, 19 September 2002 14:28 Go to next message
emme
Messages: 13
Registered: July 2002
Junior Member
WHEN I TRY TO MAKE ENABLE THE FOREIGN KEY in USER_OBJECTS,I AM GETTING THE FOLLOWING MESSAGE
ORA-02298: cannot enable TABLEA.FOREIGN_KEY - parent keys not found

THIS FOREIGN KEY DEPENDING ON TABLEB IS PRIMARY KEY.

Please some body help me!

My oracle verison is 8.0.4
my os :NT4

Thanks in Advance
emme
Re: URGENT PLEASE [message #53454 is a reply to message #53440] Fri, 20 September 2002 11:48 Go to previous message
sai sreenivas jeedigunta
Messages: 370
Registered: November 2001
Senior Member
Emme,
The Column to which u r Foreign key is getting mapped, is it Enabled ? Check it out..I think there lies the problem ..Its not present / Primary key is not set..

sai
Previous Topic: REMOTE MANAGEMENT TOOLS INSTALLATION
Next Topic: datafile use problem
Goto Forum:
  


Current Time: Thu Dec 26 23:36:53 CST 2024