Hi

Anyone know if its possible to change the sqlplus prompt to reflect my new
database connection? For example below you can see that I logged into
sqlplus as user 'user1' on database 'db1' on box 'box1', however if I use
the connect command to change to 'user2' to database 'db2' the sqlplus
prompt does not change. I know the connection settings are picked up
whenever I log into sqlplus via the glogin.sql file however I do not want to
keep logging in and out of sqlplus just to pick up the new connection
settings.

Thanks in advance

David

------------------------------------------------------------------
SQL*Plus: Release 9.2.0.1.0 - Production on Thu Apr 28 16:36:11 2005

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.


Connected to:
Oracle9i Enterprise Edition Release 9.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production

[Email address protected] connect user2/[Email Address Removed] address protected]
----------------------------------------------------------------

Systems Operations, Thus Plc.
.
. . _
www.thus.net www.demon.net
email. david.[Email address protected]
internal. 740 4156
external. 0141 566 4156
mobile. 07880 502093

Oracle LazyDBA home page