How to Modify / Set SQLPlus Prompt With Connected Username and SID?

It is always better have the username and the database SID to be set in the sqlplus prompt to avoid confusions. It will be very useful to identify the database where you connected especially your work involved in multiple databases.
        1.   Setting the prompt temporarily with the current connected session.
set sqlprompt "_CONNECT_IDENTIFIER'-'_USER> "

        2.   Setting the prompt permanently with glogin.sql file.
Add the required format to the glogin.sql file located in $ORACLE_HOME/sqlplus/admin directory.
$ cd $ORACLE_HOME/sqlplus/admin

$ echo set sqlprompt "_USER'@'_CONNECT_IDENTIFIER> ">>glogin.sql
DBA Tips Data Pump Reference


Post a Comment


dba topics. Copyright 2011-17 All Rights Reserved | Site Map | Contact | Disclaimer | Google