| problem in refrehing materialized view [message #120317] |
Thu, 19 May 2005 01:07  |
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 2032 times)
|
|
|
|
| Re: problem in refrehing materialized view [message #120449 is a reply to message #120317] |
Thu, 19 May 2005 17:03  |
Frank Naude
Messages: 4590
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
