Re: Newbie question - how to select db with sql plus?

When you log on to SQLPlus, you're telling it which database instance you want. How this looks depends on the client you're using. In Unix, you log in as

loginid_at_dbname

and your TNS file should point you to the appropriate host/instance for that db name. In Windows, I forget what the boxes on the login dialog are named, but the third one is where you specify your db instance. In the Windows scenario, you need to set up a database alias for your new instance in SQL*Net configuration.

What type of SQLPlus client are you using?

nbc

On Sun, 28 Mar 1999 15:33:48 GMT gerhard.hofmann_at_nospam.planat.de (Gerhard Hofmann) wrote:

>Hello,
>
>I am a newbie to oracle and need some advice. Right now, I only used
>Ingres DBMS.
>
>I installed Oracle 8 on an NT machine. I can connect to the default
>database with SQL Plus and run SQL queries against it.
>
>Now I wanted to use another database. I created a new one "ORC0" with
>the Database Assistant. BTW, can I change that name?
>
>My problem: I have no idea how to connect to that new databse with SQL
>Plus. Any tips?
>-------------------------------------------------
>Please copy all answers to my email address
>gerhard.hofmann_at_planat.de
>Remove the "nospam"
Received on Sun Mar 28 1999 - 11:39:03 CST