Re: Oracle Istance

From: Nicholas Mudie <nmudie_at_chello.com>
Date: Fri, 23 Feb 2001 09:12:47 GMT
Message-ID: <jQpl6.1705$Ed3.415850@amsnews02.chello.com>

try

select * from dba databases;
v$databases

but for a complete list try
http://help.netscape.com/kb/corporate/19980606-1.html

Nicky Mudie
Chello Broadband
(I've got a trigger question posted, can you answre it?) ""Marco Pinzuti"" <marco.pinzuti_at_consulenti.csi.it> wrote in message news:001701c09d74$d900a840$bb6a660a_at_csi.it... Can anyone tell me how it's possible to get to know which are the istances of a database? In others words I'd like to know whether it exists an Oracle table where it's possible to get the name of the HOST-STRING that Sql-Plus asks for when I'm going to connect to Database.

Thanks in advance

--

Received on Fri Feb 23 2001 - 03:12:47 CST