Hi:
With Oracle 8i, I always modified $ORACLE_HOME/sqlplus/admin/glogin.sql, and
added
set termout off
col site_name noprint new_value site_name_new
select 'SQL> ' site_name from dual;
select user
|| substr(proc.program, instr(proc.program,'@'),
instr(proc.program,' ') - instr(proc.program,'@'))
|| '-SQL> ' site_name
from v$process proc
where proc.pid = 2;
set sqlprompt '&&site_name_new'
set termout on
so that when a user launches sqlplus, it would show something at prompt like
[EMAIL PROTECTED]>
instead of
SQL>
I found that doing this in 9i will prevent me starting up my instance, when
I use
sqlplus '/as sysdba'
In 8i, I always used svrmgrl to bounce db so there was no problem with
modified glogin.sql.
Has anyone found a work-around in 9i so that sqlplus prompt displays
"username" and "hostname" when launched? I know there is a new
_CONNECT_IDENTIFIER in 9i, but that's not good enough.
TIA.
Guang
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Guang Mei
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
