Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2002
    Posts
    78

    Unanswered: Unable to get values for table DEPT

    Hai
    In order to view the table statistics ,i had execute the below procedure but it returns error.It should be appreciate if any one helps


    Thanks in advance
    mohan


    DECLARE
    num_rows number;
    num_blocks number;
    avg_row_len number;
    begin
    dbms_stats.get_table_stats('MOHAN','DEPT',NULL,'ST ATS','APP',num_rows,num_blocks,avg_row_len);
    dbms_output.put_line('num_rows='||num_rows||',num_ blocks='||num_blocks||',avg_row_len='||avg_row_len );
    end;
    /
    DECLARE
    *
    ERROR at line 1:
    ORA-20000: Unable to get values for table DEPT
    ORA-06512: at "SYS.DBMS_STATS", line 1569
    ORA-06512: at "SYS.DBMS_STATS", line 1603
    ORA-06512: at line 6

  2. #2
    Join Date
    Jan 2003
    Location
    Dordrecht, The Netherlands
    Posts
    95
    Ty analyzing the table (ANALYZE TABLE DEPT COMPUTE STATISTICS).

    I'm not familiar with DBMS_STATS, maybe you also need to set the parameter TIMED_STATISTICS to TRUE.

Posting Permissions

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