Home » Developer & Programmer » Reports & Discoverer » Reports:Data from 2 databases
Reports:Data from 2 databases [message #90299] Wed, 26 January 2005 12:15 Go to next message
Maya Menon
Messages: 10
Registered: January 2005
Junior Member
Hi all,

We have a requirement where we need to extract data from two reports and display them in an html page. The report is existing and we show data in one database right now. But we have to show the data in 2 database also.

Right now we create reports using sql files and use Oracle views for selecting the data we want.
Can anyone please give me an example of how to acheive this ?

Thanks,
Maya

Report message to a moderator

Reports:Data from 2 databases: Please help:Updated [message #90308 is a reply to message #90299] Thu, 27 January 2005 07:26 Go to previous messageGo to next message
Maya Menon
Messages: 10
Registered: January 2005
Junior Member
Hi all,

We have a requirement where we need to extract data from two schemas and display them in an html page. The report is existing and we show data in one schema right now. But we have to show the data in 2 schema also.

Right now we create reports using sql files and use Oracle views for selecting the data we want.
Can anyone please give me an example of how to acheive this ?

Thanks,
Maya

Report message to a moderator

Re: Reports:Data from 2 databases: Please help:Updated [message #90318 is a reply to message #90308] Fri, 28 January 2005 05:57 Go to previous messageGo to next message
ÇÊ
Messages: 15
Registered: September 2002
Junior Member
It may be possible that you could create a materialized view with a snapshot log to "move" the data from the schema in db 2 to the schema in db 1.

Then, things become much simpler.

Report message to a moderator

Re: Reports:Data from 2 databases: Please help:Updated [message #90321 is a reply to message #90318] Fri, 28 January 2005 11:57 Go to previous message
Maya Menon
Messages: 10
Registered: January 2005
Junior Member
can u give an example please

Report message to a moderator

Previous Topic: parameter in lov of another parameter
Next Topic: Urgent: An Excel File from Report
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat May 18 07:46:22 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.