Re: Using system call to change oracle instance

[james rader <raderj@SMTPGATE.ADM.INTELSAT.INT>]

We run client/server against many instances on many physical boxes. When we
wish to switch we issue a new "CONNECT" statement containing the alternative
SQL*NET connect string (which includes the SID.) See page 136 of the SQR
V3.0 manual.
- Jim Rader
-------------
Original Text
>From LYOUNG@SMTPGATE (Larry Young) {LYoung@CONTINENTAL.COM}, on 9/4/97 10:18
AM:
To: SQR-USER@SMTPGATE (Multiple recipients of list SQR-USERS)
{SQR-USERS@USA.NET}

A question I hope someone can help resolve. I have a number of Oracle
instances on one unix box.  Instead of running my  program a number of
times, I am attempting to change the instance in SQR. So far I have been
unable to change the instance in SQR. Any ideas?   The code is

        call system using 'export ORACLE_SID=ne;'   #SID

When I run this I get the error ORACLE_SID=ne; is not an identifier.

As an fyi I am able to change the oracle instance at the unix prompt
using
        export ORACLE_SID=ne;

Any ideas would be greatly appreciated.  Thanks in advance.