Re: Fw: OT - Getting fired for database oops

  • From: Tony van Lingen <tony_vanlingen@xxxxxxxxxxxxxxxxxxxxx>
  • To: jkstill@xxxxxxxxx
  • Date: Wed, 20 May 2009 09:40:52 +1000

And it takes precedence over the ORACLE_SID setting too! Hence my favourite take on the database in $PS1:


  ${TWO_TASK:+T:}${TWO_TASK:-"${ORACLE_SID:+S:}${ORACLE_SID:-NONE}"}

That way I know also which of the two is in force.

Cheers,
Tony

Jared Still wrote:
On Tue, May 19, 2009 at 12:28 PM, Rich Jesse <rjoralist@xxxxxxxxxxxxxxxxxxxxx <mailto:rjoralist@xxxxxxxxxxxxxxxxxxxxx>> wrote:


    To tell the truth, I thought TWO_TASK went out with Oracle8.
     Never use it.
    Never see a need to.  Although that preference alone would be a
    great reason
    to include it in the prompt as a warning, for those of y'all that have
    multiple admins.


Nope, still alive and kicking, used by Oracle Apps.


Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

Other related posts: