Re: How to find Oracle Packs already installed

From: Deepak Sharma <sharmakdeep_oracle_at_yahoo.com>
Date: Thu, 19 Feb 2009 07:36:45 -0800 (PST)
Message-ID: <979482.98913.qm_at_web52803.mail.re2.yahoo.com>

Thanks. Yes, it can see the listed ones in "v$option"

---

From: "Channa, Santhosh" <Santhosh.Channa_at_McKesson.com> To: Chris.Taylor_at_ingrambarge.com; sharmakdeep_oracle_at_yahoo.com; oracle-l_at_freelists.org Sent: Thursday, February 19, 2009 9:26:58 AM Subject: RE: How to find Oracle Packs already installed

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       

--

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