Re: sqlplus ?

From: <Ed.Stevens_at_nmm.nissan-usa.com>
Date: Wed, 09 Sep 1998 13:21:10 GMT
Message-ID: <6t5vc6$2nl$1@nnrp1.dejanews.com>

As K Poone said, you can specify the service when you start the sqlplus. You can also specify it after SQLPlus is up, with the command 'connect my_userid/my_pswd_at_my_db' If you don't want to expose the password, use 'connect my_userid_at_my_db' and you will be prompted for the password.

In article <6sjauc$ieq$1_at_hermes.is.co.za>, "nick" <nick_at_NOSPAM.co.za> wrote:
> I have 3 oracle databases on my machine how can i use sqlplus to access a
> specific database without changing my users ORACLE_SID.
>
> Regards
>
> Nick
>
>

--
Ed Stevens
Nissan Motor Mfg. Corp., USA

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Wed Sep 09 1998 - 08:21:10 CDT