Not able to drop materialized view.
KRMRMar 6 2013 — edited Mar 7 2013Hello All,
I imprted a schema which has materialized views in it. I am trying to drop all materialized views. Only couple of them failing with "ORA-02449: unique/primary keys in table referenced by foreign keys". I did check for dependent objects and I could see they are only referenced by the table that is create during MVIEW creation to hold mview data. See below for details.
drop materialized view XXXXX.LANGUAGES_MV;
ORA-02449: unique/primary keys in table referenced by foreign keys
select * from dba_dependencies where referenced_name='LANGUAGES_MV';
OWNER NAME TYPE REFERENCED_OWNER REFERENCED_NAME REFERENCED_TYPE REFERENCED_LINK_NAME DEPENDENCY_TYPE
XXXXX LANGUAGES_MV MATERIALIZED VIEW XXXXX LANGUAGES_MV TABLE REF
My database version is 11.2.0.3( and PSU level 5). Any inputs are greatly appriciated.
Thanks,
KRMR.