Linking with Foreign Keys

Posted on 16th Feb 2014 07:03 pm by admin

I have been getting an erro when I try and link:

create table Faculty_Specialty (I_Name varchar2(20) not null, Specialty varchar2(40) not null);

using :

alter table faculty_specialty modify (foreign key (I_Name) references faculty);

to:

Create table Faculty (I_Name varchar2(20) primary key);

The following error occurs:

SQL> alter table faculty_specialty modify (foreign key (I_Name) references faculty (I_Name));
alter table faculty_specialty modify (foreign key (I_Name) references faculty (I_Name))
*
ERROR at line 1:
ORA-02298: cannot validate (ORDB029.SYS_C0027281) - parent keys not found

I Know it's elementry but I can figure out why this is happening.....

Your Answer:

Login to answer

Other forums

Image upload - determine folder
I have an upload script that may be accessed from different directories. Problem is, the script is m

Change of partner analyse in sales orders
Hello,

I changed the partner analyse for sales orders and added a new mandatory partnerro

Recognising Revenue daily
Hello.
Has anyone come across daily recognition of deferred income?
We want to implement R

button.click += new eventhandler() not works in if(!ispostback)
i want to use button.clcik event in function VIewScrap() which is called in if(!ispostback) but itdo

Unifying logins of two different scripts
I have two different game scripts which I want to embed on my own site. The problem is I don't want

how do i make a string??
hey guys,
can someone please tell me how to put data from the glob function into a string

help with image text
Hi ...

see i need the text of the name and number to start in the center and always be in the

dynamic table with forms
I have a table that is populated with mysql data and in teh first column there is a raido button tha

Sending a hyperlink through mail
HI all,
I am sending a mail to outlook mailbox of a user using FM SO_NEW_DOCUMENT_ATT_S

Word filter problem
Hello,

im trying to make a filter for words inputted in to my website but i want to store the