select * from global_name
sometimes gives more info, depending on setup
"dsmcd" <dsmcd_at_uswestmail.net> wrote in message
news:NqMi9.320$K%.104814_at_news.uswest.net...
> "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 - 18:19:11 CDT
