Good morning to everybody,
I've to resolve this situation: I've a collection of many different databases, all identical, and the name of those databases is stored inside a table in another "central
management" database.
In an ideal world, I'd like with a single query to be able to recover the name of each database from the table that does contains them, and use it to do a query on each table on
each databse joining the results.
At the moment I'm doing it by external code, but performaces are awfull...
At first I tough something similar to
select * from tab_databases,dblink('dbname=' || tab_databases.name,'select count(id) from tab_data')
could work, but it seems its not allowed to reference rows from another table inside the from level.
Putting dblink outside that level allow me to use the dynamic dbname, but in that case I would need a row resource, while dblink give back a table resource...
Is it possible to resolve this inside the databse?
Thanks a lot...
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
