-
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.
Thanks
-
In your case simple replications is enough
1)Simply create a dblink from ORA2---> ORA1
in a schema where table is needed
2)Create a snapshot log in ORA1 using primary key
3) Create a snapshot in ORA2 in the same schema where db_link is created and table is needed
If you do this far(are all the records from ORA1 to ORA2
replicated just after creating a snapshot,then let us know
I'll give you further help if you re thru with the above steps
Cheers
-
-
what is the difference between Snapshot Replication and Materialized View Replication ?
Thanks
-
before 8.1.6 they call it snapshot
from 8.1.6 onwards we call it materialized view or a snapshot
Materialized view is superset of snapshot+properties of view
check with Documentation
view + material = Materialized view
GOOD LUCK