Oracle Streams on Readonly DB
edited Jan 15, 2014 8:28PM in GoldenGate, Streams and Distributed Database (MOSC) 2 commentsAnswered
We have several doubts regarding Oracle Streams setup:1. Is it possible to setup Oracle Streams on a source DB which is a Read-only Standby Active Data Guard Database ?
2. What are the requirements for Oracle Streams source DB ?
3. Is it possible to setup Oracle Streams on a destination DB which is a Read-Write access Oracle DB , but destination tables are not to be modified ?
4. How can we know while quering the destination DB , which records were created during last hour ? Is there any out-of-the box column indicating such information for each row ?
2. What are the requirements for Oracle Streams source DB ?
3. Is it possible to setup Oracle Streams on a destination DB which is a Read-Write access Oracle DB , but destination tables are not to be modified ?
4. How can we know while quering the destination DB , which records were created during last hour ? Is there any out-of-the box column indicating such information for each row ?
1