I use select comp_name, comp_version, status from dba_registry of course in a corporate environment your configuration management tools might help as well. On 3/12/07, dba1 mcc <mccdba1@xxxxxxxxx> wrote:
I have a database which I created it on 9.2.0.1. Recently I upgraded ORACLE software from 9.2.0.1 to 9.2.0.8. I can NOT remember I upgrade that database or not? Does there has way to check database has been upgrade or not? Thanks. --------------------------------- We won't tell. Get more on shows you hate to love (and love to hate): Yahoo! TV's Guilty Pleasures list.
-- Niall Litchfield Oracle DBA http://www.orawin.info -- //www.freelists.org/webpage/oracle-l