select * from v$version maybe...

>>> Celoiu Manuel <Manuel.[Email Address Removed] 03/29/02 07:32AM >>>
Hi DBAs

It's there, in Oracle Dictionary, a table that contains the OS version
?

I would like to get the same information as in the trace file wich
result
after executing this statement :

ALTER DATABASE BACKUP CONTROLFILE TO TRACE;

EX., in the header :

Dump file C:\ORACLE\admin\INASS\udump\ORA00193.TRC
Thu Mar 28 11:32:29 2002
ORACLE V8.1.6.0.0 - Production vsnsta=0
vsnsql=e vsnxtr=3
Windows NT Version 4.0 Service Pack 4, CPU type 586
Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production
With the Partitioning option
JServer Release 8.1.6.0.0 - Production
Windows NT Version 4.0 Service Pack 4, CPU type 586 <----- this is
the
information that I need

Thanks,
Manuel


--------
Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed]
Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html

Oracle LazyDBA home page