Re: How do I start SQL*Plus under a different database?

Hi Malcolm,

sqlplus -?

      <logon> ::= <username>[/<password>][@<connect_string>] | / | /NOLOG That's what it shows; I didn't realize that <connect_string> == SID.

Thanks,
Peter.

"Malcolm Dew-Jones" <yf110_at_vtn1.victoria.tc.ca> wrote in message news:3e233417_at_news.victoria.tc.ca...
> Peter Chatterton (peter_at_chatterton.name) wrote:
> : I'm running 9iAS on win2K sp3.
>
> : There are 2 databases, OEMREP and AGENCYDB; the former being the
> : default/primary/whatever.
>
> : My Question is: How can I start SQL*Plus under the other db?
>
>
> C:\> sqlplus user/password_at_database_name
>
>
> The "sqlplus" command name is normally wrong, it will be something more
> like sql9w.exe (though that is also wrong).
>
>
> You can probably run the command with the -h switch to get a summary of
> the command line usage of the command.
>
> C:\> sqlplus -h
Received on Mon Jan 13 2003 - 17:50:04 CST