You could just use login.sql instead, on a per user basis.
If you don't want login.sql to be used, just edit or unset SQLPATH.
Maybe other options available for this in 9i. A perusal of the sqlplus
manual may prove useful.
Jared
"Guang Mei" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED] 10/29/2003 08:24 AM
|
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: sqlplus prompt question in 9i |
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).