showing -ve value in num_nulls!!!
Date: Tue, 1 May 2001 13:49:32 +0800
Message-ID: <3aee4f2c.0_at_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
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 - 07:49:32 CEST