Monday, September 17, 2007

ORA-02273: this unique/primary key is referenced by some foreign keys

It's very easy to reproduce this situation:
create table test1(
test1_parent_id number,
col1 varchar2 (30),
constraint test1_pk primary key (test1_parent_id)
)
/
create table test2(
test2_id number,
test1_child_id number,
col2 varchar2(30),
constraint test2_fk foreign key (test1_child_id) references test1(test1_parent_id)
)
/
alter table test1 drop constraint test1_pk
/
ORA-02273: this unique/primary key is referenced by some foreign keys

As the error message suggests, there is no difference between primary key and unique constraints:

create table test3(
test3_parent_id number,
col1 varchar2 (30),
constraint test3_uq unique (test3_parent_id)
)
/
create table test4(
test4_id number,
test3_child_id number,
col2 varchar2(30),
constraint test4_fk foreign key (test3_child_id) references test3(test3_parent_id)
)
/
alter table test3 drop constraint test3_uq
/
ORA-02273: this unique/primary key is referenced by some foreign keys

See message translations for ORA-02273 and search additional resources.



ORA-02273: a questa chiave primaria o unica fanno riferimento chiavi esterne
ORA-02273: a esta clave única/primaria hacen referencia algunas claves ajenas
ORA-02273: aquesta clau única o primària està referenciada per alguna clau forana
ORA-02273: cette clé unique/primaire est référencée par des clés étrangères
ORA-02273: Einige Fremdschlüssel beziehen sich auf diesen Primär-/eindeutigen Schlüssel
ORA-02273: αυτό το μοναδικό/πρωτεύον κλειδί αναφέρεται από μερικά ξένα κλειδιά
ORA-02273: denne unikke/primære nøgle er refereret af fremmede nøgler
ORA-02273: denna UNIQUE/PRIMARY KEY refereras från några främmande nycklar
ORA-02273: denne entydige/primære nøkkelen blir referert av fremmednøkler
ORA-02273: tähän yksikäsitteiseen tai perusavaimeen viittaa viiteavaimia
ORA-02273: erre az egyedi/elsődleges kulcsra más idegen kulcsok hivatkoznak
ORA-02273: această cheie unică/primară este referită de câteva chei externe
ORA-02273: Naar deze unieke/primaire sleutel wordt verwezen door verwijzende sleutels.
ORA-02273: esta chave exclusiva/primária é referenciada por algumas chaves externas
ORA-02273: esta chave exclusiva/primária é referenciada por algumas chaves externas
ORA-02273: на этот уникальный/первичный ключ ссылаются вторичные ключи
ORA-02273: na tento jednoznačný/primární klíč se odkazují cizí klíče
ORA-02273: tento jednoznačný/primárny kľúč je odkazovaný niektorými cudzími kľúčmi
ORA-02273: obce klucze odwołują się do tego unikatowego/głównego klucza
ORA-02273: bu benzersiz/birincil anahtara bazı yabancı anahtarlar tarafından başvuruluyor
ORA-02273: this unique/primary key is referenced by some foreign keys

No comments:

yes you can!

Two great ways to help us out with a minimal effort. Click on the Google Plus +1 button above or...
We appreciate your support!

latest articles