Re: Materialized view question

Jared,

Thanks for the reply. As I understand a complex MV is one where the select query is something like:

select * from t1_at_db1
union all
select * from t1_at_db2
union all
select * from t1_at_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_at_gmail.com> 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_at_gmail.com> 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
> > --
> > http://www.freelists.org/webpage/oracle-l
> >
>
>
>
> --
> Jared Still
> Certifiable Oracle DBA and Part Time Perl Evangelist
>
>

--
http://www.freelists.org/webpage/oracle-l