Re: Using materialized view on 2 databases

You would probably do it via database link. For example, select * from table A union select * from table B_at_remote_db. This would give a union of table A, which resides locally and table B, which resides remotely. Of course this would mean that your tnsnames.ora would have to reference the remote database, your database links would have to be current, and that whatever user you're connect with has select privileges on the remote db.

kumar wrote:

> Hello friends,
>
> Is it possible to create a materialized view on tables that are on 2
> databases on the same database server.
> I have 2 oracle 8i databases DB01 and DB02 running on a single Windows 2000
> server.
>
> Can I create a materialized view on tableA of DB01 and tableB of DB02?
>
> Can anyone please state an example or a link of the example. While I
> searched the documentation, it is all about the tables in same database.
>
> Please shed some light.
>
> Regards
> Kumar

--
Phillip