Re: How to identify the 'current' instance
From: <Derek>
Date: 1996/10/16
Message-ID: <542c9s$q93_at_merengue.worldcom.com>#1/1
Date: 1996/10/16
Message-ID: <542c9s$q93_at_merengue.worldcom.com>#1/1
>running under hp-ux, after exporting ORACLE_SID=TST, TWO_TASK=DEV and
>then logging on to sql*plus with 'sqlplus user_id_at_T:host_name:PRD' is
>there any way to query the correct current instance?
>thanks in advance.
use the following in sql*plus
select * from global_name; Received on Wed Oct 16 1996 - 00:00:00 CEST