Re: Way to list GV$ Columns ?

From: Mark Bobak <Mark.Bobak_at_proquest.com>
Date: Wed, 28 Aug 2013 15:38:48 +0000
Message-ID: <CE43916F.348DC%Mark.Bobak_at_ProQuest.com>

Perhaps you were thinking of V$FIXED_VIEW_DEFINITION and/or V$FIXED_TABLE and/or V$INDEXED_FIXED_COLUMN?

-Mark

On 8/28/13 8:49 AM, "Christopher.Taylor2_at_Parallon.com" <Christopher.Taylor2_at_Parallon.com> wrote:

>Nevermind I think. It appears DBA_TAB_COLUMNS has this info - I just
>didn't think it contained all the views but maybe it does.
>Chris
>
>From: Taylor Christopher - Nashville
>Sent: Wednesday, August 28, 2013 7:48 AM
>To: oracle-l_at_freelists.org
>Subject: Way to list GV$ Columns ?
>
>I thought there was a master view that listed all the V$ and GV$ columns
>but I can't seem to put my hands on it now.
>
>Is there a way to generate this (specifically search for a column_name)
>on fixed v_$/gv_$ tables?
>
>Thanks!
>
>Chris D. Taylor
>Oracle DBA
>Parallon ITS
>6640 Carothers Parkway
>Franklin, TN 37067
>P: 615.344-8419
>christopher.taylor2_at_parallon.com<mailto:christopher.taylor2_at_parallon.com>
>www.parallon.com<http://www.parallon.com>
>
>
>--
>http://www.freelists.org/webpage/oracle-l
>
>
>
>

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

Received on Wed Aug 28 2013 - 17:38:48 CEST