Re: How could I find oracle version?

From: DJ <nospamplease_at_goaway.com>
Date: Tue, 26 Aug 2003 22:52:44 +0100
Message-ID: <SEQ2b.5306$L15.1486@newsfep4-winn.server.ntli.net>

"Mikito Harakiri" <mikharakiri_at_ywho.com> wrote in message news:umQ2b.14$533.253_at_news.oracle.com...
> OK, oracle instance version is in v$instance. What about the database? I
> have dbf files which I don't have idea what version they are. I would
> recreate control files but what upgrade script am I supposed to run?
> Speaking of manageability wouldn't it be wonderful to have a unified
script
> so that it would be oracle who would have to figure out from what version
to
> upgrade, not poor me?
>
>

v$database
v$version
dba_data_files

and to find all ure datafiles in a backup control statement 'alter database backup control file to trace;' Received on Tue Aug 26 2003 - 16:52:44 CDT