Re: How to determine the patch level of a database ?

Am Fri, 09 Jul 2004 01:39:05 -0700 schrieb Le JeanMimi:

> - we patched some of the databases running on the machine ... but not
> all.
>
> The problem is : we don't remember exactly which databases were
> patched.
>
> Is it possible to retrieve this information somewhere ? (patch level
> of the datafiles ?)

If yuo have executed the upgrade scripts:

select * from v$version;

If you havn't, look at the time stamps of the oracle executables.

Roman Received on Fri Jul 09 2004 - 08:32:30 CDT