Re: How could I find oracle version?

"DJ" <nospamplease_at_goaway.com> wrote in message news:SEQ2b.5306$L15.1486_at_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
> dba_data_files

There is no oracle version there.

> v$version

This one shows you the instance version.

For example i have 9.2 software and 8.1.7 datafiles. 9.2 would be in v$version after database mounted, but is 8.1.7 recorded anywhere?

> and to find all ure datafiles in a backup control statement 'alter
database
> backup control file to trace;'

I know all the datafiles anyway.

P.S. After creating control file I'm trying to open database (migrate) but having:

ORA-00402: database changes by release 9.2.0.0.0 cannot be used by release 8.1.0.0.0
ORA-00405: compatibility type "Locally Managed SYSTEM tablespace"

If I set compatible=8.1.7 then the message changes and displays

ORA-00402: database changes by release 9.2.0.0.0 cannot be used by release 8.1.7.0.0
ORA-00405: compatibility type "Locally Managed SYSTEM tablespace"

What is going on? Received on Tue Aug 26 2003 - 19:18:54 CDT