Re: how do i connect sqlplus without indicating the service name?

> For NT, I believe you just have to set your Oracle Home to your
 database's
> oracle home.

For NT, you can set the LOCAL environment variable (or at HKLM\SOFTWARE\ORACLE, a string with value <SERVICE_NAME>):

C:\> SET LOCAL=MY_INSTANCE
C:\> SQLPLUS system/manager_at_my_instance
is now equivalent to:
C:\> SQLPLUS system/manager

HTH Jose

--
-=[ Sancho ]=-


Sent via Deja.com http://www.deja.com/
Before you buy.