A voir également:
- ORA-02291
- Ora-00600 ✓ - Forum Programmation
- Ora-12154 ✓ - Forum Oracle
- Ora-06502 ✓ - Forum Oracle
- Ora-02291 - Forum Oracle
- Ora-00920: opérateur relationnel non valide ✓ - Forum Oracle
1 réponse
Bonjour,
Il manque des info dans la table maitresse ou il fau supprimer dans la table filles !
comment trouver les lignes
select child.owner||'.'||child.table_name||'.'||child.column_name||' must exist in '||
parent.owner||'.'||parent.table_name||'.'||parent.column_name
from
all_cons_columns child
, all_cons_columns parent
, all_constraints c
where c.owner='OWNER_XXXX'
and c.constraint_name='FK_XXXXX'
and child.owner=c.owner
and child.constraint_name=c.constraint_name
and parent.owner=c.r_owner
and parent.constraint_name=c.r_constraint_name
and child.position=parent.position
/
Il manque des info dans la table maitresse ou il fau supprimer dans la table filles !
comment trouver les lignes
select child.owner||'.'||child.table_name||'.'||child.column_name||' must exist in '||
parent.owner||'.'||parent.table_name||'.'||parent.column_name
from
all_cons_columns child
, all_cons_columns parent
, all_constraints c
where c.owner='OWNER_XXXX'
and c.constraint_name='FK_XXXXX'
and child.owner=c.owner
and child.constraint_name=c.constraint_name
and parent.owner=c.r_owner
and parent.constraint_name=c.r_constraint_name
and child.position=parent.position
/