Jared, Thanks for the reply. As I understand a complex MV is one where the select query is something like: select * from t1@db1 union all select * from t1@db2 union all select * from t1@db3; However problem with this is, if any of the remote database is down, then the whole query will fail and none of the refresh will happen. I am tentatively looking at collecting the data from 10 or so databases in to a single database. I was trying to create 10 MV (for 10 remote tables) on a single pre built table to get the data. Any ideas!! Thanks Sandeep On 7/14/05, Jared Still <jkstill@xxxxxxxxx> wrote: > http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96540/statements_63a.htm#2063795 > > search for the word 'complex' > > Also try: > http://www.oracle.com/technology/products/oracle9i/daily/nov06.html > http://www.oracle.com/technology/products/oracle9i/daily/oct17.html > http://www.oracle.com/technology/oramag/oracle/05-mar/o25data.html > > HTH > > Jared > > > > On 7/14/05, Sandeep Dubey <dubey.sandeep@xxxxxxxxx> wrote: > > > > Hi, > > > > Can we have a single materialized view being refreshed from multiple > > remote tables? What I want to do is replicate data from multiple > > tables to a single table. > > > > Thanks > > > > Sandeep > > -- > > //www.freelists.org/webpage/oracle-l > > > > > > -- > Jared Still > Certifiable Oracle DBA and Part Time Perl Evangelist > > -- //www.freelists.org/webpage/oracle-l