I don't know whether it's foolproof, but if you do
SELECT banner
FROM v$version
You see something like
SQL> select banner from v$version;
BANNER
----------------------------------------------------------------
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
PL/SQL Release 9.2.0.1.0 - Production
CORE 9.2.0.1.0 Production
TNS for 32-bit Windows: Version 9.2.0.1.0 - Production
NLSRTL Version 9.2.0.1.0 - Production
Which indicates that you're connected to a Windows machine. If you need
more precision (i.e. which version of Windows), I suspect you would need to
shell out to the operating system, either by telnetting to the machine or by
writing a Java stored procedure.
Justin Cave
Distributed Database Consulting, Inc.
http://www.ddbcinc.com/askDDBC
-----Original Message-----
From: Agarwal Ashish
[mailto:oracledba-ezmlmshield-x54473428.[Email address protected]
Sent: Tuesday, August 03, 2004 11:16 PM
To: LazyDBA Discussion
Subject: How to know the o/s for a remote database
Hi,
Which Data dictionary view will tell me the o/s on which our remote databse
is running?
Or is there any other way to know this?
Thanks
Ashish
"DISCLAIMER: PLEASE NOTE "change in our mail id. It has changed from
@hpsglobal.com to @pstsi.com".The information in this message is
confidential and may be legally privileged. It is intended solely for the
addressee. Access to this message by anyone else is unauthorised.If you are
not the intended recipient, any disclosure, copying, or distribution of the
message, or any action or omission taken by you in reliance on it,is
prohibited and may be unlawful. Please immediately contact the sender if
you have received this message in error. Thank you."
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com To unsubscribe: see
http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com By using this list you agree to
these terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page