Home » SQL & PL/SQL » SQL & PL/SQL » materialized views
materialized views [message #206701] Fri, 01 December 2006 03:07 Go to next message
Messages: 34
Registered: November 2006
Location: india

here is my query

we have two databases
for ex DB1 and DB2

i have a table A in DB1
I am loading the data from A to table B in DB2( via Datastage ETL tool )

now i have a table C in DB1 to be loaded to table D in DB2.

But here(Table C in DB1) i want to look up table B which is in DB2.

Note: there is no DB link between two DB's(DB1 and DB2)

for this i am creating a materialized view for the table B in DB2.

now i want to take the data present in table B in DB1 for table c with the help of MV created in DB2.

Could you please help me out in approaching this issue

remembere there should'nt be any DB links.

A Prassana.
Re: materialized views [message #206703 is a reply to message #206701] Fri, 01 December 2006 03:14 Go to previous message
Messages: 20847
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
How do you plan to create a materialized view without a database link?

If those databases are not connected, you'll probably have to take export in one DB and import it into another.
Previous Topic: database desing concepts
Next Topic: how to avoid query output when called from shell script
Goto Forum:

Current Time: Wed Oct 26 00:50:58 CDT 2016

Total time taken to generate the page: 0.06699 seconds