Re: Materialized view question

Check the Data Warehousing guide as well.

A complex MV is defined as one that uses a JOIN or filter condtion.

As for ideas, I suggest you setup some test cases and play with it a bit.

10 databases? Sounds like you need to devise an ETL strategy and get your customers to tell you how to handle outages.

ie. refresh with the missing data? or wait until it is all available?

Jared

On 7/14/05, Sandeep Dubey <dubey.sandeep_at_gmail.com> wrote:
>
> 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
> >
> >
>

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

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