Re: change sqlprompt at the time of switching user

From: gazzag <gareth_at_jamms.org>
Date: 3 Apr 2007 02:52:19 -0700
Message-ID: <1175593939.227610.232830@y80g2000hsf.googlegroups.com>

On 3 Apr, 03:36, "Ana C. Dent" <anaced..._at_hotmail.com> wrote: [deletia]
> Please note the file name; gLOGIN.sql
> It is invoked only upon initial LOGIN.
>

It seems to me that someone better go back to tahiti.oracle.com and reread  every every manual located at
http://tahiti.orcle.com. According to the documentation here, http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14357/ch12040.htm#sthref2899, "Glogin/login files are called for each reconnect."

E.g.

SQL*Plus: Release 10.2.0.1.0 - Production on Tue Apr 3 10:37:56 2007

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connected to:
Oracle Database 10g Release 10.1.0.4.0 - Production With the OLAP and Data Mining options

SYSTEM_at_DB1 > connect test1_at_DB2
Enter password: ********
Connected.
TEST1_at_DB2 > connect system_at_DB2
Enter password: ******
Connected.
SYSTEM_at_DB2 > connect test3_at_DB3
Enter password: ******
Connected.

TEST3_at_DB3 >
TEST3_at_DB3 >
TEST3_at_DB3 >
TEST3_at_DB3 > connect system_at_DB3

Enter password: ********
Connected.
SYSTEM_at_DB3 > select * from v$version;

BANNER

---

Oracle9i Release 9.2.0.4.0 - Production
PL/SQL Release 9.2.0.4.0 - Production
CORE 9.2.0.3.0 Production
TNS for 32-bit Windows: Version 9.2.0.4.0 - Production NLSRTL Version 9.2.0.4.0 - Production

SYSTEM_at_DB3 > Peter, include the following line in your $ORACLE_HOME/sqlplus/admin/ glogin.sql file:

SET SQLPROMPT "_USER'@'_CONNECT_IDENTIFIER > " Also note the line in the documentation that states: "It is recommended that you add SET SQLPLUSCOMPATIBILITY 10.2.0 to your scripts to maximize their compatibility with future versions of SQL*Plus."

HTH -g Received on Tue Apr 03 2007 - 04:52:19 CDT