Xref: alice comp.databases.oracle.server:28646 Path: alice!news-feed.fnsi.net!newsfeed1.earthlink.net!feeder.qis.net!newsfeed.internetmci.com!204.238.120.130!news-feeds.jump.net!nntp2.dejanews.com!nnrp1.dejanews.com!not-for-mail From: Ed.Stevens@nmm.nissan-usa.com Newsgroups: comp.databases.oracle.server Subject: Re: sqlplus ? Date: Wed, 09 Sep 1998 13:21:10 GMT Organization: Deja News - The Leader in Internet Discussion Lines: 23 Message-ID: <6t5vc6$2nl$1@nnrp1.dejanews.com> References: <6sjauc$ieq$1@hermes.is.co.za> X-Article-Creation-Date: Wed Sep 09 13:21:10 1998 GMT X-Http-User-Agent: Mozilla/2.0 (compatible; MSIE 3.01; Windows NT) X-Http-Proxy: 1.0 NMMSIT02, 1.0 x7.dejanews.com:80 (Squid/1.1.22) for client 209.64.87.66 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@my_db' If you don't want to expose the password, use 'connect my_userid@my_db' and you will be prompted for the password. In article <6sjauc$ieq$1@hermes.is.co.za>, "nick" 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