Tuesday, September 29, 2009

Job Saving Prompt

If you are using Oracle on Linux, then it would be highly beneficial to use the following prompt:

export ORACLE_HOSTNAME=`hostname`
PS1=’${ORACLE_HOSTNAME}:${ORACLE_SID}$’

With the above prompt you are less likely to perform operations intended for another database in another database.

No comments: