Unable to drop a materialized view due to contraints
Hi to all
I am trying to drop a MV on my database and have successfully deleted the remaining MV's but am having some problems with this one MV. The error I get is an obvious one but frustrating none the less. The error is as follows:
ORA-02449: Unique/primary keys in table referenced by foreign keys.
So, I have looked at the MV and see if it has and unique/primary key constraints. The only thing referenced is the PK_KEY for the table when running the following query;
select * from user_constraints where table_name='ORDER_ITEMS';
Can anyone point me in the right direction.
Regards to all that reply.