Re: Novice: Retrieve Service Name

"Alistair Thomson" <thomson_alistair_at_yahoo.co.uk> wrote:
>hi
>
>connect as system and type
>
>select name,value from v$parameter where name like 'service%';
>
>should do it
>
>Alistair

Thanks, that returns the SID, which is good, I can use that.

But what I was hoping for was retrieving the service name (from Net8 Config / tnsnames.ora).

Any other suggestions?

Thx,
D. Received on Fri Sep 20 2002 - 16:29:17 CDT