Re: How to get the SID name ?
From: Eugene Gardner <Gene_at_VaxMan.prestel.co.uk>
Date: Tue, 05 Jan 1999 19:36:54 GMT
Message-ID: <3692471c.27385220_at_news.prestel.co.uk>
Date: Tue, 05 Jan 1999 19:36:54 GMT
Message-ID: <3692471c.27385220_at_news.prestel.co.uk>
You're all missing the point of the question. It was
> does enybody know, how to get the oracle SID-ALIAS name (alias for the
> instance from the tnsnames.ora file)
> from a PLSQL programm or from sqlplus ?
As I answered before, this is just not possible. If the question was "how
to get the Instance name (as distinct from the database name)" then the
answer is to look at INSTANCE in the V$THREAD table.
Eugene Gardner (Unemployed). Received on Tue Jan 05 1999 - 20:36:54 CET