Question On Analyze command
I analyzed one particular table , Then I quesried the following table dba_tab_col_statistics. I got following result .
TABLE_NAME LOW_VALUE HIGH_VALUE
TEST_MIG C102 C10A
TEST_MIG 53535353535353535353 53535353535353535353
could u pl explain me the column (low value and High value) in this table "dba_tab_col_statistics" and its values. Actual structure of the table which I analyzed is
Name Null? Type
------------------------------- -------- ----
thanks in advance
nobody answer my question in this forum, why dont u help
no reply because u can get these information in documentation easily. but i think u don't want to try hard. any way -
this information comes from dba_tab_columns. it is for backward compatibality with orace7.
low_value - low value in that particular column
high_value - high value in that particular column
you have missed out the column name in your output. the information stored is in raw format . hence 'C102' . you can check this by -
select min(column_name) from table_name
select rawtohex(yourvalue) from dual;
you will get C102 .
8i OCP DBA
Click Here to Expand Forum to Full Width