Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Using materialized view on 2 databases

Using materialized view on 2 databases

From: kumar <sgnerd_at_yahoo.com.sg>
Date: 4 Nov 2003 04:12:35 -0800
Message-ID: <d13fd832.0311040412.5fa89d1d@posting.google.com> 





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
Received on Tue Nov 04 2003 - 06:12:35 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US