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

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.

Thanks,
A Prassana.
Re: materialized views [message #206703 is a reply to message #206701] Fri, 01 December 2006 03:14 Go to previous message
Littlefoot
Messages: 20891
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: Sun Dec 04 14:26:49 CST 2016

Total time taken to generate the page: 0.04757 seconds