Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: verifiing 8.1.7.4.1 upgrade to 8.1.7.4.x
Try (might need as SYS)
column comp_name format a35
column status format a20
column version format a11
select comp_name, status, substr(version,1,10) as version
from dba_registry
order by comp_name;
HTH
tED
"Ivette Dumois" <ivettedumois_at_hotmail.com> wrote in message
news:654ecf81.0404151414.267764e3_at_posting.google.com...
> I have upgraded our test 8.1.7.4.1 database to 8.1.7.4.13. I would
> like to verify this fact.
>
> In the readme it does state that all the products will not display the
> version number 8.1.7.4.13, because it's a cummulative patch.
>
> I would like to see at least one file with the version number greater
> than 8.1.7.4.1
>
> querying the database, v$instance still yields 8.1.7.4.1
>
> Any ideas?
>
> thanks
Received on Thu Apr 15 2004 - 18:52:56 CDT