Skip to Content
Jun 24, 2014 at 02:39 PM

How to run a select against multiple databases


Dear experts,

I need to run a select against all our databases, which are running on a separate server each.

I found this:

Looping between multiple servers for SQL*Plus

which seemed to be doing the trick, but it relies on /etc/oratab, but in our environment this file

is not in use, i.e.

/var/opt/oracle/oratab - this file has comments only and does not contain any real entries

/oracle/<SID>/11203/install/oratab - this file has 0 size

Thank you!