My method of replication testing:
1. execute from within the replication db:
"select 'replication' db, name from schema.emp where employee_id=1
union
select 'master' db, name from schema.emp@master where employee_id=1"
This displays both values of a specific row in both db's.
2. Update the master value;
"update schema.emp@master set name='TEST!' where employee_id=1"
3. execute a refresh
"EXECUTE DBMS_MVIEW.REFRESH('schema.emp','F')"
where F=Fast; C=Complete.
4. Execute te statement under point 1 to see the result
5. Execute to see the used refresh-type:
"select mview_name,last_refresh_type from all_mviews"
The result via a db link is alway 'COMPLETE', when replicating within one db, the result is always 'FAST'!
Hmmm...When I create a snapshot that refreshes on commit, I receive a ORA-01031 Insufficient privileges (even as SYS) 
Can someone please help me with this fast refresh problem? Metalink has documents about this, but all doc's are about complicated replication environments.
I only want to duplicate data to a different db...
Thanks in advance.
Erik
Last edited by efrijters; 06-19-2003 at 10:28 AM.
An expert is one who knows more and more about less and less until he knows absolutely everything about nothing.
Reply With Quote