OraFAQ Forum: Reports & Discoverer » Reports source from more than one database

Home » Developer & Programmer » Reports & Discoverer » Reports source from more than one database

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Reports source from more than one database [message #229785]

Tue, 10 April 2007 01:16

SpeakurMind
Messages: 14
Registered: June 2006

Junior Member

Hi,

I'm using reports 10g.There is a requirement wherein my source of the report ( tables/views) maybe pointing to more than one database i.e. table A maybe present in database DB1 and table B in DB2. Since the table B is very huge, it is present in a seperate databse DB2.

I need to link both these tables in my report.Is it possible to design a report wherein the tables/views?

I've developed reports wherein the tables are from a single database and not sure if the possibility of referencing tables from more than one database exists in 10G.

Please help.

Report message to a moderator

Re: Reports source from more than one database [message #229790 is a reply to message #229785]

Tue, 10 April 2007 01:24

ab_trivedi
Messages: 460
Registered: August 2006
Location: Pune, India

Senior Member

hi,
I will try and once done I will let you know.
Ashu

Report message to a moderator

Re: Reports source from more than one database [message #229798 is a reply to message #229785]

Tue, 10 April 2007 01:40

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

In a schema located in any of those databases create a database link to another database and a view as

CREATE VIEW tables_united AS
SELECT * FROM table_in_this_schema
UNION ALL
SELECT * FROM table_in_another_database@database_link;

Base your report on a view instead of a table.

Also, you might consider using a materialized view instead of an ordinary view which will might make report run much faster than the one over a database link.

Report message to a moderator

Re: Reports source from more than one database [message #229813 is a reply to message #229798]

Tue, 10 April 2007 01:56

SpeakurMind
Messages: 14
Registered: June 2006

Junior Member

Thanks all..I shall try with the materialized view and shall let u know in case of any issues Littlefoot.Thanks for the speedy reply.

Report message to a moderator

Previous Topic:	Error Running report in 9i
Next Topic:	Reports Issue

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 30 01:47:04 CST 2024