hello,
we have oracle 10gR2 development database.
i am trying to gather statistics on one of the index of a table...
but it continues to flash back errors..
SQL>USER22/****@ORCL
Connected.
SQL> desc index_stats;
Name Null? Type
----------------------------------------- -------- ----------------------------
HEIGHT NUMBER
BLOCKS NUMBER
NAME VARCHAR2(30)
PARTITION_NAME VARCHAR2(30)
LF_ROWS NUMBER
LF_BLKS NUMBER
LF_ROWS_LEN NUMBER
LF_BLK_LEN NUMBER
BR_ROWS NUMBER
BR_BLKS NUMBER
BR_ROWS_LEN NUMBER
BR_BLK_LEN NUMBER
DEL_LF_ROWS NUMBER
DEL_LF_ROWS_LEN NUMBER
DISTINCT_KEYS NUMBER
MOST_REPEATED_KEY NUMBER
BTREE_SPACE NUMBER
USED_SPACE NUMBER
PCT_USED NUMBER
ROWS_PER_KEY NUMBER
BLKS_GETS_PER_ACCESS NUMBER
PRE_ROWS NUMBER
PRE_ROWS_LEN NUMBER
OPT_CMPR_COUNT NUMBER
OPT_CMPR_PCTSAVE NUMBER
SQL> EXEC DBMS_STATS.GATHER_INDEX_STATS(ownname => 'USER22',indnam
e=>'IX_ORDERDTL',estimate_percent=>DBMS_STATS.AUTO_SAMPLE_SIZE, stattab=>'INDEX_
STATS',statown=>'USER22');
BEGIN DBMS_STATS.GATHER_INDEX_STATS(ownname => 'USER22',indname=>'
IX_ORDERDTL',estimate_percent=>DBMS_STATS.AUTO_SAMPLE_SIZE, stattab=>'INDEX_STAT
S',statown=>USER22); END;
*
ERROR at line 1:
ORA-20000: TABLE "USER22"."INDEX_STATS" does not exist or
insufficient privileges
ORA-06512: at "SYS.DBMS_STATS", line 10640
ORA-06512: at "SYS.DBMS_STATS", line 10664
ORA-06512: at line 1
AM I MISSING ANYTHING?
THANKS AND REGARDS