Re: How to execute queries that query different db at same time?

Try creating a database link from one server (first) to another (second). Then run both queries on the first server.

HTH,
Brian

abjiang wrote:
>
> I have two sets of queries that query two different databases. I need to
> batch them together and execute them at same time. What is the best ay
> of doing this? Thanks in advance for any advice.
>
> Abby
>
> --
> Posted via http://dbforums.com

-- 
===================================================================

Brian Peasland
dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"