Oracle Database Discussions

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.