Path: news.easynews.com!newsfeed1.easynews.com!easynews.com!easynews!news.he.net!news-hog.berkeley.edu!ucberkeley!newsfeed.stanford.edu!postnews1.google.com!not-for-mail
From: JusungYang@yahoo.com (Jusung Yang)
Newsgroups: comp.databases.oracle.server
Subject: Re: ORA-02266 when refreshing materialized view
Date: 12 Dec 2002 10:12:00 -0800
Organization: http://groups.google.com/
Lines: 11
Message-ID: <130ba93a.0212121012.28567473@posting.google.com>
References: <2b68fda7.0212110150.3c126fb2@posting.google.com>
NNTP-Posting-Host: 64.172.44.14
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1039716720 13518 127.0.0.1 (12 Dec 2002 18:12:00 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: 12 Dec 2002 18:12:00 GMT
Xref: newsfeed1.easynews.com comp.databases.oracle.server:169537
X-Received-Date: Thu, 12 Dec 2002 11:25:59 MST (news.easynews.com)

Can you post your MV definition? Most likely you have other tables
referencing the MV. Check user_dependencies.

- Jusung Yang

ngcl@sf-express.com (Charles) wrote in message news:<2b68fda7.0212110150.3c126fb2@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?