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
Sabeen
Messages: 25
Registered: March 2005
Location: Pakistan
Junior Member
hello,
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 1479 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: 4579
Registered: April 1998
Senior Member
Hi,

Quote:

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.

Frank
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: Thu Mar 28 11:11:43 CDT 2024