I haven't encountered such paranoia before but I can think of at least two
possible ways to deal with the issue.
- Customise (g)login.sql to modify the sqlplus command prompt to display
the service name you are attached to.
- Run tools against live and dev environs using different Oracle homes.
I am sure that others will point out the weaknesses of either approach
(approach 1 is liable to give a false sense of confidence under some
circumstances)
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
"dsmcd" <dsmcd_at_uswestmail.net> wrote in message
news:cigX8.34$dg5.22725_at_news.uswest.net...
> Sybrand Bakker <postbus_at_sybrandb.demon.nl> wrote:
>
> >But why on earth would you need to do that?
> >wouldn't you better run select * from global_name to see which
> >database you are connected to if you are in doubt?
>
> You're right, of course. I'm also concerned about the new
> assistant starting soon, and also about when we're not using
> Oracle tools, but using the front end's tools for database
> maintenance. Both these concerns can be dealt with, but an extra
> safety net might help.
>
> Thank you,
> D.
>
Received on Thu Jul 11 2002 - 13:30:58 CDT
