Re: MTS not workin ??

From: quarkman <quarkman_at_myrealbox.com>
Date: Tue, 19 Aug 2003 19:35:55 +1000
Message-ID: <oprt5bl5zgzkogxn@haydn>

On Tue, 19 Aug 2003 06:16:12 +0200, Harald Maier <maierh_at_myself.com> wrote:

>
> Only a small correction:
>
> SERVICE should be SERVICE_NAME in the tnsnames.ora file.
>
> It's a little bit confusing. In the dispatcher clause of the
> initialization file the service name is specified by 'SERVICE' and in
> the tnsnames.ora file it is specified by SERVICE_NAME. Why they have
> not chosen the same word? It's pity ...
>

Quite right, my mistake (doing it at 6am this morning from memory, so maybe you will forgive me!).

As for consistency of naming things.... I agree.

It's not quite the same thing, I realise, but it always gets me that sometimes I have to select table_name, sometimes object_name, sometimes segment_name and (quite indefensibly, I think) sometimes seg_name. I understand that tables are just one sort of segment, but segment_name AND seg_name?? Huh???

Thanks for the correction, anyway.

Regards
HJR Received on Tue Aug 19 2003 - 04:35:55 CDT