DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Question on Analze command....!

  1. #1
    Join Date
    Feb 2002
    Posts
    36

    Question On Analyze command

    HI friends,
    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
    ------------------------------- -------- ----
    X NUMBER(1)
    Y VARCHAR2(10)
    thanks in advance
    bye
    SIva

  2. #2
    Join Date
    Feb 2002
    Posts
    36
    nobody answer my question in this forum, why dont u help
    siva....!

  3. #3
    Join Date
    Dec 2001
    Posts
    221
    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
    and then

    select rawtohex(yourvalue) from dual;

    you will get C102 .
    Santosh Jadhav
    8i OCP DBA

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width