Streams 'synchronous capture' and rule_set_name
edited Sep 25, 2011 9:30PM in GoldenGate, Streams and Distributed Database (MOSC) 2 commentsAnswered
Hi everybody,
I have an architecture with 2 servers Standard Edition Oracle 11gR2.
In one server i have my online database and another server historics. I have thought replicate data
with streams. In online database only need 6 months (i delete old data) but in historics database i need every data.
I have 2 question:
- With SE i can configure 'synchronous capture' and streams works similar or there is any limitations.
- Can i configure with 'synchronous capture' that only insert from online database to historics but no reply delete?
i don't know if with condition in rule_set_name.
Thanks in advance.
I have an architecture with 2 servers Standard Edition Oracle 11gR2.
In one server i have my online database and another server historics. I have thought replicate data
with streams. In online database only need 6 months (i delete old data) but in historics database i need every data.
I have 2 question:
- With SE i can configure 'synchronous capture' and streams works similar or there is any limitations.
- Can i configure with 'synchronous capture' that only insert from online database to historics but no reply delete?
i don't know if with condition in rule_set_name.
Thanks in advance.
0