i would like to know what type of replication better deal with my application. i got OLTP database on 8.1.6 (ORA1) and application (APP1), i will receive the data from the real-time, i will process the data and insert into the table's.
I got another application (ORA2)and applicatoin (APP2) which is going to use only one table from my OLTP database ( ONLY SELECTS approximately 400 transactions/second).
My question is can i replicate only one table from my ORA1 database on to ORA2 database? so that my APP2 application will select the data from the database ORA2. If it is correct,
what kind of replication methode i have to follow.