ms sql hosting
What should i write in HOST STRING while logging into SQL *Plus?
I’m not able to log into SQL *Plus. It asks for USERNAME, PASSWORD and HOST STRING. I tried SCOTT TIGER, SYSTEM MANAGER combinations of username and password but do not know what to write in host string. Can you suggest alternatives?
here is the format
scott@databasestring
tiger
databasestringis the database name defined in your ‘tnsnames.ora’ located in ‘X:\oracle\ora92\network\admin’.
here is the lines in my PC
databasestring= //write this name after ‘@’
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 111.111.111.111)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ORCL)
)
)
Importing Data From Excel Using SQL 2005 by Mark Wisecarver
