RE: How to find Oracle Packs already installed

From: Channa, Santhosh <Santhosh.Channa_at_McKesson.com>
Date: Thu, 19 Feb 2009 09:26:58 -0600
Message-ID: <75064C4060A3A24787B52E1F7D3E410C0A01C271_at_DBQV3005.na.corp.mckesson.com>



Its sys.v_$option.

Regards,
Santhosh Channa

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Taylor, Chris David Sent: Thursday, February 19, 2009 10:22 AM To: sharmakdeep_oracle_at_yahoo.com; oracle-l_at_freelists.org Subject: RE: How to find Oracle Packs already installed

I think its V$option if i'm not mistaken..

Sent from my phone

-----Original Message-----

From: "Deepak Sharma" <sharmakdeep_oracle_at_yahoo.com> To: "oracle-l_at_freelists.org" <oracle-l_at_freelists.org> Sent: 2/19/09 9:14 AM
Subject: How to find Oracle Packs already installed

What is a quick way to find (thru SQL or otherwise) all the packs (partitioning, diagnostic etc.) that are installed in a database on a given server?

-Thanks
      

--

http://www.freelists.org/webpage/oracle-l
--

http://www.freelists.org/webpage/oracle-l Received on Thu Feb 19 2009 - 09:26:58 CST

Original text of this message