DBLINK vs MV replication question

Hi everyone.

We need to replicate some tables from a remote 8i db running in a Solaris box, to my 9.2.0.6 wich also runs on Solaris. The replicated tables are for read only purposes. The base tables have 7 millons rows aprox.

IŽd like to hear your opinions, regarding wich method is best, as the DBA says it doesn't worth using read-only materialed views, because we can achieve same results using just a dblink, and replicating the tables in our local db with
'create table as select * from emp_at_remotedb'

Having read Advanced Replication and Datawarehousing Guide manuals, I did not find such recommendation, so I wonder if you can give some arguments against the DBAŽs, or else why he is right. Some simple comparison between both techniques will be appreciated.

Thanks a lot.(sorry for my english)

Regards.
Gerard. Received on Wed Oct 05 2005 - 21:35:13 CDT