Hi all,
I have 3 databases. First one is my production database and second db is my standby database which is in read only mode. The third one is my another application database which need to refresh the data from my Standby database.

Any one has bright idea on what is the fastest way to refresh data (This contains the join tables to make up a new table, of course all those base tables are getting from the standby database)? My current solution like following, Create table abc as select a,b from tab1@dblink, tab2@dblink where tab1.key = tab2.key; This is work.But I found this method is quite slow.

My initial idea is to create the materialized view just apply logs to the destination, but due to the read only mode standby database, the database seems not allow me to do that. So I need to create table rather MV.

Any suggestions are very much appreciated.

Thanks