| no matching unique or primary key for this column-list [message #651] |
Tue, 26 February 2002 00:47  |
philarmo
Messages: 15
Registered: February 2002
|
Junior Member |
|
|
hi, i create one table with :
create table s_dept
(id number(5)
CONSTRAINT s_dept_id_pk PRIMARY KEY,
name varchar2(30)
CONSTRAINT s_dept_name_nn NOT NULL,
region varchar2(30)
CONSTRAINT s_dept_region_nn NOT NULL,
CONSTRAINT s_dept_name_region_un UNIQUE
(name,region))
THEN, i want to create a table two with two columns filled by the first table
create table s_emp
(id number(7)
constraint s_emp_id_pk PRIMARY KEY,
surname varchar2(30)
constraint s_emp_surname_nn NOT NULL,
dep number(5)
constraint s_emp_dep_fk REFERENCES
s_dept (id),
region_id varchar2(30)
constraint s_emp_region_id_fk REFERENCES
s_dept (region),
Constraint s_emp_dep_region_id_un UNIQUE
(dep, region_id))
BUT I HAVE A MSG ERROR : ORA-02270: no matching unique or primary key for this column-list
|
|
|
|
| Re: no matching unique or primary key for this column-list [message #652 is a reply to message #651] |
Tue, 26 February 2002 01:34  |
pratap kumar tripathy
Messages: 660
Registered: January 2002
|
Senior Member |
|
|
the table s_emp is tring to reference the s_dept (region) and there is no unique/primary key exist for region in s_dept table
-------------------------------------
ORA-02270 no matching unique or primary key for this column-list
Cause: An attempt was made to reference a unique or primary key in a table with a CREATE or ALTER TABLE statement when no such key exists in the referenced table.
Action: Add the unique or primary key to the table or find the correct names of the columns with the primary or unique key, and try again.
----------------------------------------
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
