Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Oracle Version

Re: Oracle Version

From: Jared Still <jkstill_at_gmail.com>
Date: Sun, 11 Feb 2007 07:56:29 -0800
Message-ID: <bf46380702110756n6919196aj4f6a3bef0ad594d2@mail.gmail.com>


select * from v$version;

On 2/11/07, rajendra.pande_at_ubs.com <rajendra.pande_at_ubs.com> wrote:
>
> Guys
>
> During upgrade, is there any query that can be used to find the existing
> version of ORACLE while the database is opened with the new
> ORACLE.binaries for upgrade.
>
> For example upgrading from 8174 to 10G the query should give 8174 while
> the database is opened with 10G - obvioulsly before the
> upgrade(catpatch) is run.
>
> -RP
>
> Thanks
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

--
http://www.freelists.org/webpage/oracle-l
Received on Sun Feb 11 2007 - 09:56:29 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US