dropping materialized view

[Jeroen van Sluisdam]

Hi,   I have a serious problem in dropping a snapshot/mview I cannot find whatever constraint is blocking this. Any advice is appreciated   SQL> drop snapshot deca.mediums; drop snapshot deca.mediums * ERROR at line 1: ORA-02449: unique/primary keys in table referenced by foreign keys     SQL> drop materialized view deca.mediums; drop materialized view deca.mediums * ERROR at line 1: ORA-02449: unique/primary keys in table referenced by foreign keys   SQL>  SELECT * FROM dba_constraints where table_name = 'MEDIUMS';   no rows selected   I get the samen results when dropping as owner and as sys   Details: Oracle 9.2.0.4 HP-UX11.11   Tnx,   Jeroen