Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> showing -ve value in num_nulls!!!

showing -ve value in num_nulls!!!

From: Aparna <bliss_is_ignorance_at_hotmail.com>
Date: Tue, 1 May 2001 13:49:32 +0800
Message-ID: <3aee4f2c.0@news.tm.net.my>

hi all,

a colleague of mine was analysing and sizing some tables and he got this strange output for

select column_name, num_nulls, num_distinct from user_tab_columns where table_name = 'TABLE1';

the value displayed for num_nulls for one column (step_no) was -56 when infact there are no rows containing null values for that column... he then tried creating another table as a duplicate of table1 using

create table temp1 as select * from table1;

on checking the num_nulls in temp1, the result was the same -56 for the column step_no...

just to give u all a slight background on this table... data has been loaded into table1 from another oracle table thru SQL script... there was a composite primary key constraint (task_no + step_no) on this column which has been disabled during the data loading and not enabled as yet... as u can see step_no is the second column of this composite primary key... the value for num_nulls displayed for the task_no which is the first column of the composite primary key is accurate... we even tried dropping the constraint, but the result is the same...

the data is not corrupt.. the application using the data is working fine and showing accurate data.. but what we don't understand is how can num_nulls display a -ve value??? any guesses???

thanx for ur attention..

regards,
aparna Received on Tue May 01 2001 - 00:49:32 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US