Beautiful!!!! Thanks so much for the help! Works like a charm. Am I able to 
make Kwrite my default editor in sqlplus, like in winXX? I tried to edit a 
statement and it was trying to make the changes in the terminal, but I 
couldn't figure out ehat commands to use. It may be emac environment. If 
anything I would like to change it to vi..

On Saturday 28 February 2004 12:16 pm, Matt Alexander wrote:
> On Sat, 28 Feb 2004, Mike wrote:
> > Progress I love it!!!
> > Ok, so now when I start sqlplus I try to login, but I get an error
> >
> > ORA-12162: TNS:net service name is incorrectly specified
> >
> > So I went back to /usr/lib/oracle/10.1.0.2/network/admin/tnsnames.ora and
> > I removed the other tnsnames, ie 119dp and 164, as I got the file from
> > the cisora website. When you login thru windows it asks you for the host
> > string, in linux it is not...
>
> In Linux you can specify it like this:
>
> sqlplus username/password@connect-string
>
> or...
>
> sqlplus username@connect-string
>
> or...
>
> Set the default environment variable to always use your particular
> connect-string in your profile config file:
>
> export TWO_TASK=cis119abc
>
>
>
> ---------------------------------------------------
> PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us
> To subscribe, unsubscribe, or to change  you mail settings:
> http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss

-- 
  1:07pm  up 73 days 20:20,  3 users,  load average: 0.24, 0.06, 0.02
Linux linux 2.4.20-4GB #1 Mon Mar 17 17:54:44 UTC 2003 i686 unknown unknown 
GNU/Linux

---------------------------------------------------
PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us
To subscribe, unsubscribe, or to change  you mail settings:
http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss