Re: sys.col_usage$.intcol# = 1001

  • From: rjamya <rjamya@xxxxxxxxx>
  • To: dmann99@xxxxxxxxx
  • Date: Wed, 2 Dec 2009 07:47:32 -0500

perhaps you have some virtual columns (probably function based index etc) on
some of your tables that have intcol#-1001 ? intcol is #real_columns (i.e.
kernelcol max value for which is 1000) plus any virtual columns. e.g. of
virtual column is function based index on the table?

i am guessing this could be one of the reasons, of course i could be wrong.

Raj

On Mon, Nov 30, 2009 at 2:01 PM, David Mann <dmann99@xxxxxxxxx> wrote:

> While running down some statistics differences between some Dev and
> Test databases I started digging into sys.col_usage$.
>
> For some of the tables I am seeing some records where intcol#=1001. My
> google-fu is weak today (must be too much turkey over the past 4
> days). These records dont' seem to t correspond to any actual columns
> in the tables -- can anyone shed some light on what this data tagged
> with the magic number is used for?
>
> Thanks,
> -Dave
>
> --
> Dave Mann
> www.ba6.us - Database Stuff - http://www.ba6.us/rss.xml
> --
> //www.freelists.org/webpage/oracle-l
>
>
>


-- 
-----
Best regards
Rjamya

Other related posts: