Home » Server Options » Replication » problem in refrehing materialized view
problem in refrehing materialized view [message #120317] Thu, 19 May 2005 01:07 Go to next message
Messages: 25
Registered: March 2005
Location: Pakistan
Junior Member
i have total 15 tables.12 r replicated and 3 r non-replicated.
when i tried to refresh a table which is refrenced in non -replicated table. i foound an error. i m sending a screen shot of error. can any one help me in this regard. i will be thankful to him/her.
  • Attachment: untitled.jpg
    (Size: 123.07KB, Downloaded 651 times)
Re: problem in refrehing materialized view [message #120449 is a reply to message #120317] Thu, 19 May 2005 17:03 Go to previous message
Frank Naude
Messages: 4570
Registered: April 1998
Senior Member


ORA-12008: error in meterialized view refresh path
ORA-02266: unique/primary keys in table referenced by enabled foreign keys

if you have multiple tables with primary/foreign key relationships, you need to put them in a refresh group and refresh the group instead of the individual tables.

Best regards.

Previous Topic: Replication with different Character sets
Next Topic: Implementing (basic)Replication where server IP is constant but clients IP is Not constant
Goto Forum:

Current Time: Fri Nov 26 23:56:14 CST 2021