Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

drop materialized view ORA-02449

user521233Oct 30 2006 — edited Oct 31 2006

i am attempting to drop a materialized view so that i can recreate it with new columns in the select list.

unfortunately, i am receiving the following error:
ORA-02449: unique/primary keys in table referenced by foreign keys

can anyone provide me with a simple solution to discovering which foreign key relationships or entities are dependent on the target?

thanks in advance.

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 28 2006

Added on Oct 30 2006

#general-database-discussions

10 comments

2,952 views