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

What is SAP Avatar ?
Hi All,

This G.Satish , my boss asked me to explore on SAP Avatar. I searced in internet

Async WSAConnect failed on XP with error code = 2 ("File not found")
Hi all,

I have very strange bug, please help me if you can.

It is reproduced o

Combining Two Queries
I have two scripts that each work fine by themselves. One is a search script with a variable that de

Spliting paragraph into sentences and attach in
Here is what I am trying to do

example: Para1[123.456.789!] 3 sentences
Para2

Is it possible to put an entire 500-page book in a database with PHP?
I am working on an intranet and I was wondering if its possible to code php with mysql to enter a fu

Embedding flash object in Else statement
This is my first major project in PHP and I'm having some trouble embedding a flash object in an Els

limitations on array_unique()
Does any one know what/how imitations are applied to array_unique? I have an issue where no matter h

Keep newlines from textarea?..
I'm creating a simple encoding program, and what I want it to do is retain the newlines, as echoing

PHP Captcha Error help - replace the "die" command
Hi All,

I am after a bit of help with a Captcha spam protection box.

The site gave me

IP question
ive got 2 ip addresses both global from same user how would i detect if they are local to each other