Re: Way to list GV$ Columns ?

  • From: Mark Bobak <Mark.Bobak@xxxxxxxxxxxx>
  • To: "Christopher.Taylor2@xxxxxxxxxxxx" <Christopher.Taylor2@xxxxxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 28 Aug 2013 15:38:48 +0000

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@xxxxxxxxxxxx"
<Christopher.Taylor2@xxxxxxxxxxxx> 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@xxxxxxxxxxxxx
>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@xxxxxxxxxxxx<mailto:christopher.taylor2@xxxxxxxxxxxx>
>www.parallon.com<http://www.parallon.com>
>
>
>--
>//www.freelists.org/webpage/oracle-l
>
>
>
>


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


Other related posts: