Connect to another server and execute script from within an Oracle db

[ScottXJ]

Hello,

I'm sure this will seem like a strange question, but I'm risking the possibility of getting flamed and asking anyway. I was wondering if it is possible to connect to another server and execute a SQL script from within an Oracle database. Specifically, I'd like to perform the following:

1. Connect to another Solaris server
2. Run/Execute .SQL script residing on that server

Note: I want to perform this task from within an Oracle db

Any assistance would be appreciated!

Thanks,

Scott.

 

[SantaMufasa]

Scott,

There are certainly methods to achieve your objectives. Could you please tell us a bit more about your need?

1) Do you want to run this script from the Solaris server on a regular/recurring basis?

2) If not, is there a reason that the script must reside on the Solaris machine instead of your local PC?

3) Are there any other issues that are central to your need that we don't know about?

Mufasa
(aka Dave of Sandy, Utah, USA)
[I can provide you with low-cost, remote Database Administration services: see our website and contact me via www.dasages.com]