I have 200 nodes with Oracle 10g Standard Edition One and a DataCenter with 3 nodes Oracle 10g Enterprise Edition Real Application Clusters. My questions is, how to replicate data from each node to datacenter with the objective to centralize all data.
The database structure is the same in all nodes, and there is no conflict.
My real problem is Oracle Standard Edition One, it's not support advanced replication like Streams and Materialized Views, and i cant use other version of oracle because itīs huge money.

Please any advice?

Thanks in advance.