This content has been marked as final. Show 3 replies
Did you think about using import-export utility for this like imp/exp or impdp/expdp (could be done thought network - NETWORK_LINK)
Or you could use Database Advanced Replication http://docs.oracle.com/cd/B19306_01/server.102/b14226/toc.htm
for example Updatable Materialized Views http://docs.oracle.com/cd/B19306_01/server.102/b14226/repmview.htm#sthref396
As I read, my mistake is not putting the MV in a MV group. I have in a REFRESH_GROUP, which is a different concept?(???)
Updatable materialized views have the following properties.
They are always based on a single table, although multiple tables can be referenced in a subquery.
They can be incrementally (or fast) refreshed.
Oracle propagates the changes made to an updatable materialized view to the materialized view's remote master table or master materialized view. The updates to the master then cascade to all other replication sites.
I should create a MV group, and add it to the refresh group??
PS: I just realized there is a REPLICATION forum... is there a way to pass this thread there, or do I need to create a new one?