|
|
|
|
| Re: Refreshing the tables in Multimaster replication [message #353542 is a reply to message #353536] |
Tue, 14 October 2008 02:40   |
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 |
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 |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
