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