Queries across instances

[migregg]

Is is possible to do a query that gets data from two different instances using DOA but without setting up a dblink? Essentially, I would like to be able to use a single query of data dictionary views to compare the structure of different instances. Can this be done or would I have to query one instance, save the results, then query the other instance?

Michael Gregg

 

[Marco Kalter]

If you want to use one query, then a database link is the only option. If you can use 2 queries, then you can simply use 2 TOracleSession instances, connect the queries to them, execute them, and compare the results. There is no need to save the query results.

------------------
Marco Kalter
Allround Automations