Re: The first oracle 11.2.0 problem:

From: Mladen Gogala <mladen_at_bogus.email.invalid>
Date: Thu, 3 Sep 2009 22:29:36 +0000 (UTC)
Message-ID: <h7pg0g$47u$1_at_solani.org>

On Thu, 03 Sep 2009 22:31:12 +0100, Jonathan Lewis wrote:

>
> If you want to examine x$ definitions:
>
> set linesize 132
> set pagesize 120
> set newpage 0
>
> break on kqftanam skip page
> column kqftanam new_value m_table noprint
>
> column kqfconam heading "Column"
> column kqfcodty heading "Ext Type"
> column kqfcotyp heading "Int Type"
> column kqfcomax heading "Array Max"
> column kqfcolsz heading "Len Size"
> column kqfcolof heading "Len Offset"
> column kqfcosiz heading "Col Size"
> column kqfcooff heading "Offset"
> column kqfcoidx heading "Index"
> column kqfcoipo heading "Idx Col"
>
> ttitle -
> skip 1 -
> center m_table -
> skip 2
>
> spool x_desc
>
> select
> kqftanam,
> kqfconam,
> kqfcodty,
> kqfcotyp,
> kqfcomax,
> kqfcolsz,
> kqfcolof,
> kqfcosiz,
> kqfcooff,
> kqfcoidx,
> kqfcoipo
> from
> x$kqfta ta,
> x$kqfco co
> where
> co.kqfcotab = ta.indx
> order by
> kqftanam,
> kqfcooff
> ;
>
> spool off

Thanks Jonathan!

-- 
http://mgogala.freehostia.com

Received on Thu Sep 03 2009 - 17:29:36 CDT