SQL> truncate table alert_store;
truncate table alert_store
*
ERROR at line 1:
ORA-02266: unique/primary keys in table referenced by enabled foreign keys
SQL> SET PAGESIZE 1000
SQL> select c1.table_name as org_table_name,
2 c1.constraint_name as org_constraint_name,
3 c1.constraint_type as org_constriant_type,
4 n1.column_name as org_colun_name,
5 c2.table_name as ref_table_name,
6 c2.constraint_type as ref_constraint_type,
7 c2.constraint_name as ref_constraint_name,
8 n2.column_name as ref_column_name
9 from dba_constraints c1,
10 dba_constraints c2,
11 dba_cons_columns n1,
12 dba_cons_columns n2