tag:blogger.com,1999:blog-6949925540847199091.post6855263400516952532..comments2023-10-05T02:51:21.957-07:00Comments on Babu B: Adding Objects in ReplicationBabuhttp://www.blogger.com/profile/10439199112693842586noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-6949925540847199091.post-1504016103344298212007-11-05T22:32:00.000-08:002007-11-05T22:32:00.000-08:00Dear Babu It was an excellent doc but i have a que...Dear Babu <BR/><BR/>It was an excellent doc but i have a query regarding how to add another materialized view site <BR/>i think we should have to follow the following Steps <BR/><BR/>Create materialized view’s in your replication site.<BR/><BR/><BR/>In scott@mv02 (Another MV Site)<BR/><BR/>SQL> CREATE MATERIALIZED VIEW U_MASTER REFRESH FAST WITH PRIMARY KEY UPDATABLE AS SELECT * FROM SCOTT.U_MASTER@US.EDKAL;<BR/><BR/><BR/>Materialized view created.<BR/><BR/>We should have first create Mviewadmin at new site and then <BR/><BR/>In mviewadmin@mv01.edkal<BR/><BR/>SQL> BEGIN<BR/><BR/>DBMS_REPCAT.CREATE_SNAPSHOT_REPOBJECT(gname => '"US_REP"',<BR/>sname => '"SCOTT"',<BR/>oname => '"U_MASTER"',<BR/>type => 'SNAPSHOT',<BR/>min_communication => TRUE);<BR/>END;<BR/>PL/SQL procedure successfully completed.<BR/><BR/>and we also have to create a refresh job and then add <BR/>SQL> BEGIN<BR/>DBMS_REFRESH.ADD(<BR/>name => '"MVIEWADMIN"."US_REP"',<BR/>list => '"SCOTT"."U_MASTER"',<BR/>lax => TRUE);<BR/>END;<BR/>/<BR/><BR/>hence we can accomplish the task (adding Mv Site) ????????<BR/><BR/>Can u also please guide me how to add a site in Multimaster Replication <BR/>please Reply at <BR/>s_aazeem@yahoo.com<BR/>M.ShakeelAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-6949925540847199091.post-2888235241873686442007-11-02T22:20:00.000-07:002007-11-02T22:20:00.000-07:00Keep it up Babu,Keep Explore Replication.Good Luck...Keep it up Babu,<BR/><BR/>Keep Explore Replication.<BR/><BR/><BR/>Good Luck.Mohammed Tajhttps://www.blogger.com/profile/18022044698097362461noreply@blogger.com