Home » Server Options » Replication » Refreshing the tables in Multimaster replication (Oracle 9i, HP-UX)
Refreshing the tables in Multimaster replication [message #353522] Tue, 14 October 2008 01:55 Go to next message
sanei05
Messages: 104
Registered: September 2008
Senior Member
Hi,

I have 8 databases in a multi master replication. I want to refresh the tables in the replication. Can anyone tell the steps..
Re: Refreshing the tables in Multimaster replication [message #353536 is a reply to message #353522] Tue, 14 October 2008 02:29 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What did you read in Oracle documention yet?

Regards
Michel
Re: Refreshing the tables in Multimaster replication [message #353542 is a reply to message #353536] Tue, 14 October 2008 02:40 Go to previous messageGo to next message
sanei05
Messages: 104
Registered: September 2008
Senior Member
As far as i read,i found a procedure to refresh the tables in the materialize view. But my tables are in to materialized view and not in multimaster... so am not sure whether the refresh procedure of materialized view will work out for multi master replication.. Below is the procedure i have...


BEGIN
Dbms_Refresh.Make(
name => 'SCOTT.MINUTE_REFRESH',
list => '',
next_date => SYSDATE,
interval => '/*1:Mins*/ sysdate + 1/(60*24)',
implicit_destroy => FALSE,
lax => FALSE,
job => 0,
rollback_seg => NULL,
push_deferred_rpc => TRUE,
refresh_after_errors => TRUE,
purge_option => NULL,
parallelism => NULL,
heap_size => NULL);
END;
/


will this work out in multimaster ...
i am working on production and i am bit hesitate to directly test this on production.. i need a suggestion
Re: Refreshing the tables in Multimaster replication [message #353646 is a reply to message #353542] Tue, 14 October 2008 08:13 Go to previous message
sanei05
Messages: 104
Registered: September 2008
Senior Member
hi,

I have a below procedure to find the differences in the table for finding the data synchronization between the tables..


BEGIN
DBMS_RECTIFIER_DIFF.DIFFERENCES(
sname1 => 'contactdb',
oname1 => 'contactsteps',
reference_site => 'YYYYY.world',
sname2 => 'contactdb',
oname2 => 'contactsteps',
comparison_site => 'XXXXworld',
where_clause => '',
column_list => '',
missing_rows_sname => 'contactdb',
missing_rows_oname1 => 'contactsteps',
missing_rows_oname2 => 'contactsteps',
missing_rows_site => 'UKXA.WORLD',
commit_rows => 10);
END;
/


Also I am getting the below error..
ERROR at line 2:
ORA-06550: line 2, column 4:
PLS-00306: wrong number or types of arguments in call to 'DIFFERENCES'
ORA-06550: line 2, column 4:
PL/SQL: Statement ignored



As far i know i have given all the parameter and i dont find anything wrong. can anyone help me out... pls urgent...

[Updated on: Wed, 15 October 2008 00:14]

Report message to a moderator

Previous Topic: Views or Streaming
Next Topic: Materialized view does not refresh
Goto Forum:
  


Current Time: Thu Mar 28 07:46:18 CDT 2024