I have created multiple materialized view on my site and add them to a materialized view group; Then every object ( materialized view ) are added to a refresh group....
The materialized view is refresh fast and updatble.. when I do some update on my materialized view, changes are seen on the master site and vice-versa, BUT when i try to do the same work ( creating materialized view and add them on materialized view group ) with another Master site (lets say master site2), changes on the materialized view are note seen on the master site2.
note that i have followed steps declared on oracle documentation.
Do i have to add some command when I try to create multiple materialized view group.. or what is the reason that prevent the update on the master site..
pls help me :S
No version numbers ... no code ... no actual error messages.
No help is possible at this time.
Your post reads roughly equivalent to the following:
"I have two cars one of them starts and the other doesn't please tell me why my second car won't start."
A complete and total lack of useful information is what connects your post and my second car. To get help you need to provide ALL relevant information.
Thank you for replying..
I am a beginner in the "world of oracle".
for simplifying,,I am using oracle 10g for implementing a distributed database; In my distributed environment I have two master site (where data on every site are different) and a client (where i want to reassemble all data).
Here is my code:
*@master 1* :
-ALTER SYSTEM SET GLOBAL_NAMES=False SCOPE=SPFILE;
name => 'refg',
list => 'mv_ch',
lax => TRUE);
What was happening first, is that when the client try to update, insert or delete from mv_ch, changes are seen at master site 1 and when the master site 1 also update, insert or delete table "chercheurs", changes are seen at the client side. But is not the case between client and master site 2( no changes are made).
now after disconnect between 3 site; no changes are seen between the client and the master sites..
I afraid I'm implementing a wrong architecture. N.B_: I didn't copy a repeating code where I should create multiple materialized view and when I add them to multiple materialized group; I have no error message.