Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-02266 when refreshing materialized view
Can you post your MV definition? Most likely you have other tables
referencing the MV. Check user_dependencies.
ngcl_at_sf-express.com (Charles) wrote in message news:<2b68fda7.0212110150.3c126fb2_at_posting.google.com>...
> Hi all,
> I've got an ORA-02266 error (unique/primary keys in table
> referenced by enabled foreign keys) when having a complete refresh to
> my materialized view. What's wrong with it? How can I cure this
> problem?
Received on Thu Dec 12 2002 - 12:12:00 CST