ORA-02449: unique/primary keys in table referenced by foreign keys
891947Oct 2 2011 — edited Oct 3 2011SQL> create table empinformation
2 (
3 mobileno number(6) constraint pk_empinformation primary key,
4 address varchar(100),
5 salary number(10),
6 personalid varchar(10) constraints fk_employees_section references employee(emp_id) );
Table created.
SQL>drop table empinformation;
ORA-02449: unique/primary keys in table referenced by foreign keys